Insert Hyperlink Dialog Box

[David]

I have a text box that is a hyperlink. When the user
clicks onto the text box I want the Insert Hyperlink
dialog box to pop up. So in the On Click I want to put in
an Event Percedure that will automatically open the Insert
Hyperlink dialog instead of them having to right click
then select Edit Hyperlink. Is there a way to do this
with code?

thanks David

 

[Allen Browne]

Clicking the hyperlink ought to make it activate.
Would you consider adding a small command button next to the field?

Private Sub cmdGoHyper_Click()
Me.[NameOfYourTextBoxHere].SetFocus
RunCommand acCmdInsertHyperlink
End Sub