Hyperlink in query field

  • Thread starter Thread starter Teo
  • Start date Start date
T

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
 
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.
 
Thanks.

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

How can I do?

Thanks
 
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.
 
Back
Top