How to set an unbound MS Access textbox control as a hyperlink field?

[dpark29]

Access 2000 - If a textbox control is bound to a hyperlink field in an Access database table, the textbox appears formatted as hyperlink and when the user right-clicks the field, the Hyperlink option is available on the resulting popup Shortcut Menu form. I am developing a form that uses unbound textboxes, and I need to include a textbox that will contain a hyperlink. How do I get an unbound textbox to act like a textbox that is bound to a hyperlink field?
TIA - David

[ADezii]

Access 2000 - If a textbox control is bound to a hyperlink field in an Access database table, the textbox appears formatted as hyperlink and when the user right-clicks the field, the Hyperlink option is available on the resulting popup Shortcut Menu form. I am developing a form that uses unbound textboxes, and I need to include a textbox that will contain a hyperlink. How do I get an unbound textbox to act like a textbox that is bound to a hyperlink field?
TIA - David

Assuming your Unbound Text Box is named txtFakeHyperlink:

1. On the Format Tab of the Properties Sheet for txtFakeHyperlink, set the Is Hyperlink Option = Yes.
2. In the Click() Event of the Text Box, place the following code:
   

   Private Sub txtFakeHyperlink_Click()
     FollowHyperlink Me![txtFakeHyperlink], , True         
   End Sub

3. Only thing missing would be the pointed finger.