Exporting report to PDF

[jgelpi16]

I have a report that, due to the amount of data and layout requirements, is much larger than a legal sheet of paper. However, I have found if I export the report to PDF it works just fine. My problem is this...It appears the export method I am using relies on the default printer installed on the machine. This causes a problem because some of my users have a printer that does not play well with the large report size, and thus splices the report into two pages. Any idea on how I could force a page size on export? OR is there another way to down-size a report to a printable fashion on a 8x11 sheet of paper? Like I said, on my machine it exports to PDF fine and prints on an 8x11 sheet. Thanks in advance for your help.

        DoCmd.OutputTo acOutputReport, "rptDivBreakdown", acFormatPDF, strExportPath & "\rptDivBreakdown.pdf"

[pkstormy]

If you change the printer driver to adobe pdf or pdf creator, it should save it then to a file when trying to print.

There's some code in the code repository to change the printer driver in Access.