Hyperlink not a hyperlink?

[SBCUser666]

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?

[ADezii]

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:

'To write the Microsoft Home Page as a Hyperlink to the txtHyperlink Field on the Active Form
Me![txtHyperlink] = "Microsoft Home Page" & "#" & "http://www.microsoft.com/"