Run Time Error 7971

[tcheck]

I created a Hyperlink field in an access table that links back to a PDF file on the server. When I show the field in the form and click on it it works fine. When I create a botton with the command of

Application.FollowHyperlink Me!ReportLink

I get an error that states;

Run-Time error '7971':
Microsoft Access can't follow the hyperlink to
'#\\Servername\directory\filename.pdf#'

When I convert the link from a hyperlink to a text field and get rid of the # in the field, I am unable to open the file at all.



Thanks for your advice in advance.

[pbaldy]

Personally I use a plain text field, and this code works perfectly:

Application.FollowHyperlink Me.txtAttachment

where the field contains a path like yours.

[tcheck]

I just re-ran the form and now the link does work with a plain text field.

Is there a way to have a button on a Hyperlink field type?

[pbaldy]

I'm not sure; I've never used that data type. If I want the user to be able to click on it, I put the code above in the click or double click event of the textbox.