Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1084
  • Last Modified:

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.
0
BradleyOnTheRoad
Asked:
BradleyOnTheRoad
  • 2
1 Solution
 
Jeffrey CoachmanCommented:
BradleyOnTheRoad,

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

0
 
BradleyOnTheRoadAuthor Commented:
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.
0
 
Jeffrey CoachmanCommented:
Then I guess you will have to leave the caption as is.
;-)

JeffCoachman
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now