Return Hyperlink from Query on Text Field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Scott F. - 08 Feb 2008 23:14 GMT

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?

Reply to this Message

Jeanette Cunningham - 09 Feb 2008 03:20 GMT

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

> The select query I run returns a fully qualified result, suitable for
> hyperlinking. I would like to create an expression in my query that
[quoted text clipped - 3 lines]
> create a
> hyperlink data type on the underlying table. Any suggestions?

Reply to this Message