Converting to Hyperlink

[Philipc]

I have a database form which has many hyperlinks (to save database space) but I want to be able to transfer this database and images (in another folder) to other computers. I have added two fields "Path" and "NameofFile". I added a text box based on
"=[Path]+{NameofFile]".
How can I convert the Text box to a Hyperlink in order to open that file - or is there a better way of doing this.
I did look at the Access Help and just got confused with the coding suggested on how to make this work.
Would appreciate any help

 

[spikepl]

In the doubleclick event of the textbox, you can use the FollowHyperlink method - look it up.

 

[Philipc]

Thank you for your reply. Unfortunately I have got so confused with so many "Help" threads that I have not found any which just simply says how to use Follow Hyperlink and it is not in any of my Access "Bibles".
I did try one code I found: Private Sub Text34_Click()

Call Shell("C:\Windows\explorer.exe" & " " & Me!Text34, vbNormalFocus)

End Sub

substituting Text 34 for my Text 2, but this did not work when I added it as code to the Double Click for the Text box.
Can you help me further please.