MS Access 2000 Report needs to be PDF format with URL hyperlinks

Question

Working on an old MS Access 2000 database I didn't create. Has a working "projects report" which the client wants to send to prospects as a PDF document, replacing the currently-text-only project title with a title that is also a hyperlink linking to a web page (we can generate the URL programmatically).

Note: Access 2000 does not have a built-in "hyperlink" object for its reports as far as I know -- not sure if newer versions do or not.

Any ideas re: the best/quickest way to go about this? Development time/cost is a concern/constraint, but it's a long enough project list they'd rather not have to export the report to Word or something and manually create the URL links, exporting to PDF as a third step.

Answer 1

Check out this for creating the PDF.

http://www.lebans.com/reporttopdf.htm

As for having a URL in the PDF...I don't think it can be done. But I would wait for others to comment to be sure.

Seth