Hyperlinks in a query (Access 2003)

[Guest]

I have a field in a table named "Data" called "Reference" that is the end of
a hyperlink (so if the field value is ABC the hyperlink is
http://www.test.com/screens/Summary.asp?Ref=ABC). I am running a query off
the table and I want the a query result field for to show has a hyperlink. I
have tried 'Reference:
"http://www.test.com/screens/Summary.asp?Ref="&[Data]![Reference]' but this
doesn't work... any ideas?

 

[John Nurick]

As far as I know an Access datasheet or textbox will only display "like
a hyperlink" if it is bound to a hyperlink field in a table or query,
and not if it's bound to a calculated field like yours.

Maybe the best thing to do is to store the entire hyperlink in a
hyperlink field. If you're using a form, you could format the textbox in
blue underlined text and put code in its Click event procedure,
something like

Application.FollowHyperlink Me.ActiveControl

I have a field in a table named "Data" called "Reference" that is the end of
a hyperlink (so if the field value is ABC the hyperlink is
http://www.test.com/screens/Summary.asp?Ref=ABC). I am running a query off
the table and I want the a query result field for to show has a hyperlink. I
have tried 'Reference:
"http://www.test.com/screens/Summary.asp?Ref="&[Data]![Reference]' but this
doesn't work... any ideas?