BradleyOnTheRoad
asked on
Embed hyperlink in Access Report, then export to PDF
I would like to include a hyperlink in my report to an external web site. Once the report is generated I want to print the report to a PDF document using the Acrobat printer so that the links remain in the report so that anyone who views the PDF will be able to click the link to follow it to a web site.
I don't need the link to work within the access report, the link only needs to work once it is in the PDF document.
Thanks.
I don't need the link to work within the access report, the link only needs to work once it is in the PDF document.
Thanks.
ASKER
I created a report with a hyperlink and printed it to my Adobe Acrobat printer.
In the first case I used a label using the Google URL as the caption and the Hyperlink Address. It exported to PDF and the link worked as expected.
However, when I changed the caption to "Go to Google" it failed to create the hyperlink.
In the first case I used a label using the Google URL as the caption and the Hyperlink Address. It exported to PDF and the link worked as expected.
However, when I changed the caption to "Go to Google" it failed to create the hyperlink.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I have not seen this done in Access 2003, becaues hyperlinks are not "Clickable" in Access 2003.
It is possible to insert Hyperlinks in PDF's but you may need a more advanced PDF creation utility (Like the full version of Adobe Acrobat)
It is possible to do this in Access 2007 though. (After you install the Save as PDF add-in)
JeffCoachman