Hyperlink on a Form

[kwvh]

I am attempting to attach a link to an image (pdf) on a form. And once linked give the user the ability to click on the control and display the pdf file.

I set up a control button for the user to navigate to the pdf, then store the location in a text box control, formatted as a hyperlink. However, clicking on the hyperlink doesn't do what I expected.

Can anyone show me what I am doing wrong?

Thanks in advance for your ideas.

Ken

[HansV]

The contents of a hyperlink field have a special format:

displaytext#address#subaddress

where:

displaytext = the text shown in the text box; if omitted, the address is displayed
address = URL or path+filename
subaddress = name of the location within the web page or file to jump to (for example a bookmark); can be omitted

In your situation, you only need to specify the address surrounded by # characters:

Me.txtPDF_Location = "#" & strFile & "#"

[kwvh]

Hans,

Thanks not only for the solution but the explanation of how hyperlink fields work!

You are the best!

BTW - congratulations on MVP

Ken

[HansV]

BTW - congratulations on MVP

Thank you, Ken!