Hyperlinks driving me mad

[fat controller]

I have a form which creates a hyperlink based on the information that a user enters (filenames); when the hyperlink text is stored, it does so with hash tags at either end, which resolved my earlier problem with PDF reports where the hyperlinks wouldn't work. Now that they are working fine, the command button to view the hyperlink from the form has ceased working, and I get a runtime error '7971'

It is something to do with the hash tags on the hyperlinks, but I cannot figure out what? Oddly, the runtime error message has a number 1 added to the end of the hyperlink, but that one is not there when I step into the code.

For example, a filename of TestThis.doc would give a hyperlink of #E:\Sch\AV\TestThis.doc# - - and that hyperlink would work perfectly from the PDF report, however when I try the command button (FollowHyperlink command) I get the run time error and it shows the hyperlink as #E:\Sch\AV\TestThis.doc#1 - - I am completely befuzzeled by this one now?

 

[Ranman256]

You don't need the pound sign at the start.

 

[fat controller]

I've removed the hash at the start, and the links stop working on the PDF report.

I have a feeling I am going to have to code my way out of this?

 

[Minty]

Yup - I think you are - They need to be formatted differently in the two ways you need them to operate. #'s required on the pdf, not on the normal access forms.

 

[fat controller]

Sorted it, a wee bit of code and it works fine