Hyperlink Dialog

[cable]

I've got a hyperlink field that is going to contain document locations.
I would like to provide a button on the form that shows the edit hyperlink dialog box that access provides.

Is this possible?

If not what would I have to do to the result of the common dialog filename to make it a hyperlink?

 

[ghudson]

This command will do what you want.

DoCmd.RunCommand acCmdEditHyperlink

I personally store my links in a text field in the table. Then I use the Application.FollowHyperlink method to allow the user to click the link which will open the document or web page.

 

[cable]

I started with mine in text fields, but the 255 character limit could have been a problem! So I checked the hyperlink field which can store a lot more characters, 4k if i remember right...which i think matches the OS's limitation.

Thanks for the pointer though!

 

[cable]

I've decided that the hyperlink dialog isn't that friendly (esp for the way I'm using it which is more for files than proper hyperlinks).

So I've gone back to use the common file select dialog, but I'd thought I'd mention for others:
If you have a hyperlink field that you want to fill via code then you need to use the following:
Me.MyHyperLinkField = "#" & sMyFileName & "#"
this puts the filename as the text and links to the filename
Me.MyHyperLinkField = sMyText & "#" & sMyFileName & "#"
would put sMyText as the text but still link to the FileName