Avatar of Karen Schaefer
Karen Schaefer
Flag for United States of America asked on

Export Hyperlink to a PDF from Access 2007

Is there a way to include the hyperlink in an PDF from an Access 2007 Report, but only display the Employee Name instead of the hyperlink.

ie in the Edit Hyperlink dialog you can display different value (employee Name) and still have the hyperlink attached.

I know I asked a similar question on ee - see : https://www.experts-exchange.com/questions/27904425/Include-a-hyperlink-in-an-Access-2007-Report-that-is-exported-to-PDF.html

There is a attached sample of the Org Chart database.  I would like the Org chart to display the employee name, but allow the user to click on the name in the PDF and have the hyperlink activate.  Is this possible.  I know you can do it in a Report layout, but I must export this to an PDF for viewing on the internal Web.


Microsoft AccessMicrosoft ApplicationsMicrosoft Development

Avatar of undefined
Last Comment
Karen Schaefer

8/22/2022 - Mon
Jeffrey Coachman

Do you have the Hyperlink working on the report now?
(If the hyperlink works in the report, it should work in the PDF)

<I would like the Org chart to display the employee name, but allow the user to click on the name in the PDF and have the hyperlink activate. >
Describe in detail what you mean by "Activate"

Is this just a Hyperlink on the report (in a control, ...IsHyperlink=True )
...or is this data from a Hyperlink "field" in the table...

Got a sample...?
Karen Schaefer

Acrivate - enable - have the link open to the correct location.

I added a new field to the report for the hyperlink and that exports ok to the PDF, however I do not want to actually display the hyperlink just the employee name.

Similar to the way you can in a form - have the employee name, with hyperlink attached and when you click on the employee name it opens the link and changes the name from black to purple indicating that the person c licked on the hyperlink.

Karen Schaefer

Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Jeffrey Coachman

The PDF contains working hyperlinks, but the Report does not...?

I'm confused...
Karen Schaefer

I do not want to display the actual Hyperlink, I want to display just the employee name - when the user clicks on the name I want the hyperlink activated and the user is able to navigate to the URL location.

Jeffrey Coachman

I am still confused here
<The PDF contains working hyperlinks, but the Report does not...?>

What exactly am I supposed to be working on...?

Where is the Source for the PDF you posted?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Karen Schaefer

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Karen Schaefer

User changed mind on functionality