Unbound Textbox hyperlink

[DCrake]

Just a quicky. Have an unbound textbox on a form that has been set as a hyperlink. The link is present in the field, however I can't get it to follow the hyperlink when clicked. How do I do it?

I have tried the following on the on click event

Me.TxtHyperlink.Follow

But nothing happens

also tried

Application.Hyperlink.Follow Me.TxtHyperlink

however this first gives me a waring message then says it cannot open the link.

 

[Trevor G]

David why not use the label as the hyperlink?

 

[missinglinq]

http://bytes.com/topic/access/answe...und-ms-access-textbox-control-hyperlink-field

 

[DCrake]

Couple of things.

1. The contents were imported from Excel (where the hyperlink existed in the first place) however the file name only was imported not the path.

2. As Access does not know the path then it cannot open the file.

Q. How do I append the column from Excel so that it also brings in the path?

Q. There does not seem to be a shortcut menu for the hyperlink field also.

 

[vbaInet]

It's actually:

Application.FollowHyperlink Me.txtHyperlink

It's either you run an update query to affix the path to the file names or you hard code it:

Application.FollowHyperlink "C:\Admin\Documents\" & Me.txtHyperlink