Reports: Passing generated hyperlinks to PDF

[Charliegolf]

Hello All,
I've looked high and low for a solution for this problem, to no avail. I hope that y'all can shed some light on this.

Situation: I have created a database that we use to abstract documents. This database contains a brief description of many documents. The (supporting) documents are scanned and PDF'd and saved to a common documents folder with a distinct generated file name. I have created a hyperlink field that will automatically name the file/hyperlink based on what the user types into 2 fields.

Problem: Hyperlinks go into the Access report (preview) just fine. When I try to convert the report (or print) to PDF, the hyperlinks cease to function on the printed PDF. They appear as a hyperlink should but can't be clicked.

I have been up and down the Adobe forums, but can't seem to find a workable answer.

Any suggestions, o wise AWF members? Any help would be greatly appreciated.

 

[ChronicFear]

This isn't specifically a help to you, Charlie, but just thought I'd add that the problem is not unique to Access or something you've done in your report. Printing to PDF from Word or Excel also fails to yield usable hyperlinks. Perhaps there is some VBA work-around, but at least you should feel confident that it isn't you!