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.
BradleyOnTheRoadAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

JeffCoachman
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.