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.FollowHyperlink "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?