Hyperlink in query field

[Teo]

Hallo,

I've a query with a field that in the table is only text.
In this field I store for example a value like c:\app

I want that when I execute the query , it show me the field like
HyperLink.

Is possible?

Thanks

 

[Arvin Meyer [MVP]]

To do it in a query, you would need to set the data type in the underlying
table to a hyperlink. Doing that kills your ability to index and sort, so it
would be better to use a form to display the data. Then you can use the
hyperlink property of a textbox.

 

[Teo]

Thanks.

If want I compose the field in the query without a table behind?

How can I do?

Thanks

 

[Arvin Meyer [MVP]]

You cannot. A query uses the data from tables. There are some functions to
change datatypes, but not for OLE fields. Hyperlinks are OLE fields.