By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,155 Members | 1,046 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,155 IT Pros & Developers. It's quick & easy.

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

P: 1
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
May 21 '07 #1
Share this Question
Share on Google+
1 Reply


ADezii
Expert 5K+
P: 8,675
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:
    Expand|Select|Wrap|Line Numbers
    1. Private Sub txtFakeHyperlink_Click()
    2.   FollowHyperlink Me![txtFakeHyperlink], , True         
    3. End Sub
  3. Only thing missing would be the pointed finger.
May 22 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.