Automate setting hyperlink location

[CJ]

Hi Groupies:

I have created a hyperlink field in my table and on my form. When a record
is created, default text shows up so that the field is never empty. However,
I don't want the end user to have to right click on the hyperlink and choose
edit hyperlink to set the address.

I would prefer that if there is no address in place, the system opens the
Edit Hyperlink dialogue so that the location can be set. If there is an
address, then you would just go to that location.

I have no idea how to do this.

Any ideas?

 

[Stuart McCall]

Hi Groupies:

I have created a hyperlink field in my table and on my form. When a record
is created, default text shows up so that the field is never empty.
However, I don't want the end user to have to right click on the hyperlink
and choose edit hyperlink to set the address.

I would prefer that if there is no address in place, the system opens the
Edit Hyperlink dialogue so that the location can be set. If there is an
address, then you would just go to that location.

I have no idea how to do this.

Any ideas?

I've never tried this, but it looks like it ought to open the Edit Hyperlink
dialog (presumably only when a hyperlink has the input focus):

DoCmd.RunCommand acCmdEditHyperlink

 

[CJ]

I've never tried this, but it looks like it ought to open the Edit
Hyperlink dialog (presumably only when a hyperlink has the input focus):

DoCmd.RunCommand acCmdEditHyperlink

Hi Stuart

Thanks for the suggestion.
That command works if there is no hyperlink address. If the hyperlink has
already been established, it tries to change it.

I might just have to go with a little instruction to the users as I'm not
sure how to program around it.

 

[CJ]

I've never tried this, but it looks like it ought to open the Edit
Hyperlink dialog (presumably only when a hyperlink has the input focus):

DoCmd.RunCommand acCmdEditHyperlink

Hi Stuart

Thanks for the suggestion.
That command works if there is no hyperlink address. If the hyperlink has
already been established, it tries to change it.

I might just have to go with a little instruction to the users as I'm not
sure how to program around it.