Return Hyperlink from Query on Text Field

[Scott F.]

The select query I run returns a fully qualified result, suitable for
hyperlinking. I would like to create an expression in my query that returns
this information as a hyperlink instead of the text itself. The goal is to
have a hyperlink created in the datasheet that's returned and not to create a
hyperlink data type on the underlying table. Any suggestions?

 

[Jeanette Cunningham]

Scott,
On the form in datasheet view, select the text box you want to appear as a
hyperlink.
On the properties dialog, on the format tab, find the Is Hyperlink property
(near end of list)
and set it to yes.
If the entry in the textbox is a correctly formatted hyperlink, you will be
able to click on it and it will open the document, website etc.

Jeanette Cunningham