No, you cannot save a report in code as a pdf file. However, you can print the report using either the Acrobat Distiller (Ver. 5) or the PDF Writer (Ver. 4 and 5) and this will create the report as a pdf file - which is effectively the same thing. In order to do this you need the full Adobe Acrobat retail version; not just the Reader.
In the design view of the report, click File and then Page Setup. Click the Page tab and then Printer. This will allow you to set the default printer for this particular report. Choose Acrobat Distiller or PDF Writer to cause the report to be printed in pdf format.
If you have to full version of Adobe Acrobat installed, you can print to a PDF "printer" that Adobe sets up for you upon install. Otherwise, you can print to file using generic PostScript driver. Next, open up Adobe Distiller, select the PostScript file you just printed, and the Distiller will create you a PDF. Those are the simplest options I know of.
If you'd like to automate the output of PDF files from Access reports, specifying the file name and location at run time, take a look at our PDF and Mail Library for Access at:
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.