SELECT query to display active hyperlink

[pradh]

Hi,

I have a SELECT query to display records matching the specified criteria. The record has a hyperlink field linking it to a pdf file.

The problem is, a SELECT query displays the hyperlink as plain text. Is it possible to get an active hyperlink from a query?

Any help is appreciated.

Thanks
Pradh

 

[PHV]

You may try to play with the HyperlinkPart method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[pradh]

Thank you PH,

The query works fine in Windows XP, but it displays plain text in Windows 2000. I could not figure out a way to use HyperlinkPart method inside a query.
Is it something to do with the version of access I am using?

 

[pradh]

I querying a union query.... can this be a problem?

 

[PHV]

Have you tried something like this ?
HyperlinkPart([myURL],5) AS myLink

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244