Yet Another Hyperlink Question

[Dragon]

Okay, forgive me if this is a stupid question but sometimes the obvious escapes me…

I want to use code to produce the same effect as when you right click on a text box (formatted as hyperlink) and select Edit Hyperlink.

So that when a person left clicks on the field the Insert Hyperlink dialog box appears.

Any way to do that?

Thanks

 

[ghudson]

I want to use code to produce the same effect as when you right click on a text box (formatted as hyperlink) and select Edit Hyperlink.

So that when a person left clicks on the field the Insert Hyperlink dialog box appears.
Thanks

Private Sub test_Click()
     DoCmd.RunCommand acCmdEditHyperlink
End Sub

You will need to trap if the user clicks the Cancel button.

HTH

 

[Dragon]

Private Sub test_Click()
     DoCmd.RunCommand acCmdEditHyperlink
End Sub

You will need to trap if the user clicks the Cancel button.

HTH

Thanks. Just what i needed.