Hi,
Using Access 2016 Wondering if it is possible to print a pdf from an Access report where the the pdf displays clickable links.
I am using the following syntax in the source of an unbound control in a report :
="Url#" & [Website] & "##" & [Website]
Where "Url" is the hyperlink display text and [Website] is a field in a query with an website addresses (that vary for each record) stored in a table stored as text (rather than hyperlink) format.
The unbound control format settings in the report are:
"Is a hyperlink" = Yes
"Display as hyperlink" = Always
When viewing report in "reportview", the link shows the "Url" display name. The show tip is displayed correctly on mouse over showing the website address. When Clicking on the "url" hyperlink in the reportview, the desired website opens.
When printing to pdf, the pdf prints correctly but the link which works in report view does nothing in the pdf. The format is shown as a hyperlink but selecting the hand in the pdf viewer, no click action works.
I have searched without avail over Microsoft office / Office 365 and access forums for the past twenty years and see lots of people have the same question but cant find any real answer to this.
Seems like basic functionality that no amount of searching or testing provides even a glimmer of confirmation if this is possible or not. I have tried using different pdf printers foxit, acrobat and others. All have settings to create clickable hyperlinks. I have looked to word, excel and powerpoint (very little on this for Access). All say is possible, simply cannot get it to work.
Any suggestions greatly received even if is just confirmation is not possible despite clearly being possible from other applications.
Cheers and thanks