amy_goe
asked on
Access report w/ FollowHyperlink Links Exported to PDF
I have an access report with a list of text fields. I have turned these into hyperlinks using code and an invisible field on my report:
Application.FollowHyperlin k "http://www.mysite.com" & [ResourceURL], , True
This works perfectly when I view it in access.
I'd like to be able to export this report to a PDF and keep the links active. I could create the actual hyperlink on the report but I don't want the user to see the URL, just the title that appears in my text field. Is this possible?
Application.FollowHyperlin
This works perfectly when I view it in access.
I'd like to be able to export this report to a PDF and keep the links active. I could create the actual hyperlink on the report but I don't want the user to see the URL, just the title that appears in my text field. Is this possible?
ASKER
I'm not really clear on how I would use the href to export the report to a PDF.
I've come up with a work around by creating the url on the report with the font in the same color as the background and placing it as close to the bottom of the text field in as possible in a small font. The links work in the PDF and the hand cursor pops when you hover near the text field. Its not ideal because if you approach the text from the top with your cursor it seems to pop up the pointer a little late but its workable for now.
If anyone has any suggestions on how to do this in a more technically correct way, I'd love to hear....
I've come up with a work around by creating the url on the report with the font in the same color as the background and placing it as close to the bottom of the text field in as possible in a small font. The links work in the PDF and the hand cursor pops when you hover near the text field. Its not ideal because if you approach the text from the top with your cursor it seems to pop up the pointer a little late but its workable for now.
If anyone has any suggestions on how to do this in a more technically correct way, I'd love to hear....
As I said, I'm not sure you can do this. The PDF option in Access is somewhat limited, and generally if you need functionality above what is provided you must work with 3rd party libraries (like the Adobe SDK).
ASKER
Yes, thanks Scott. I don't have the expertise to begin mucking in the adobe SDK. And without some additional information on where to begin trying with href, I don't know what to do with that.
I knew my request seemed like a tough one but worth asking.
I knew my request seemed like a tough one but worth asking.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
That said, you could always try the standard "href" sort of syntax:
<A href="http:\\www.microsoft.com">Go To Microsoft<\a?
But I don't know if that would work on a PDF