Printing PDF in Access

Just guessing off the top of my head, I suggest you build a button that prints to the "Acrobat PDF Writer" printer.
Acrobat installs 2 printers when it is installed, the PDF Writer and the Acrobat Distiller.
YOu can send any document to the Acrobat PDF Writer, and it will be converted into a PDF.
You don't get all of the fancy features that you do when you use the Distiller (the normal way you write PDF files in MS Word, for example), but it will work.
So make your print button send the document to the PDF Writer printer.

hope this helps

It was a nice thought, but unfortunately, Access only allows printing to the default printer through VBA. The best you can do is have it bring up the report, then you can hit print to bring up the dialog box.

When using code, Access always looks to the default printer in the control panel. I've tried this before, Microsoft says it cannot be done.