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

Hyperlink not a hyperlink?

SBCUser666
P: 7
Form field (Text66) defined as Hyperlink.
Access 2003 table field defined as Hyperlink.
Using VBA I build the hyperlink and poke it into the form field. The field displays like it is a hyperlink (blue and underlined) but clicking on it does nothing. If I open the table and click on the field nothing happens. On the form, if I delete and retype just 1 character the hyperlink functions correctly (on the form and from the table). Thinking that setting the form field = to a text string somehow removed the hyperlink attribute I then did a Me.Text66.IsHyperlink = True to hopefully force the hyperlink function. No joy.

Ideas?
Mar 7 '08 #1
Share this Question
Share on Google+
1 Reply

ADezii
Expert 5K+
P: 8,735
Form field (Text66) defined as Hyperlink.
Access 2003 table field defined as Hyperlink.
Using VBA I build the hyperlink and poke it into the form field. The field displays like it is a hyperlink (blue and underlined) but clicking on it does nothing. If I open the table and click on the field nothing happens. On the form, if I delete and retype just 1 character the hyperlink functions correctly (on the form and from the table). Thinking that setting the form field = to a text string somehow removed the hyperlink attribute I then did a Me.Text66.IsHyperlink = True to hopefully force the hyperlink function. No joy.

Ideas?
This is a very common problem that many Users encounter when dealing with Hyperlinks. Assuming your Form Field is named txtHyperlink, write the Display Text then Address delimited by a Pound Sign (#) to make it a functional Hyperlink as in:
Expand|Select|Wrap|Line Numbers
  1. 'To write the Microsoft Home Page as a Hyperlink to the txtHyperlink Field on the Active Form
  2. Me![txtHyperlink] = "Microsoft Home Page" & "#" & "http://www.microsoft.com/"
Mar 8 '08 #2

Post your reply

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