Access query coloum string convert to hyperlink

I have a query that has a
string coloumn which i want to convert into a hyperlink through query

Any help appreciated

Who is Participating?
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I'm not clear what your goal is. Do you want to view the query (i.e. in Datasheet view) and have this show up as a hyperlink? If so, you can't do that.

You can convert the underlying column to a Hyperlink column, if that would work.

If you want to use this query to drive a Form, then just set whatever control you bind that column to as a Hyperlink.

So: Ultimately, what do you want to do with this hyperlink?
I doubt if this is possible as there is too much conversion involved in getting to a hyperlink.
Why do you need to do it, anyway?

Access does not need paths to be set up as hyperlinks in order to use them as hyperlinks.

For example if the field contains : c:\myfolder\xyz/jpg then when this is displayed in a form in a textbox called txtLink, you can use the textbox's click event procedure to do:

Application.Followhyperlink me.txtlink
To 'see' the composition of a hyperlink field go to the VBA Editor (Alt+F11) and type - hyperlinkpart - and have a good read.
type - hyperlinkpart - in Help and have a good read.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.