CODEWITHSUNDEEP
vbams-accesspdf
YvetteLee
YvetteLee

Reputation: 1090

Access VBA OutPutTo to PDF

I am using the following code:

 DoCmd.OutputTo acReport, "ReportName", acFormatPDF, fileName, False

I need the output pdf to fit in one page and view page horizontal. Now I am getting vertical and 3 pages.

thank you.

Upvotes: 1

Views: 3221

Answers (1)

ThunderFrame
ThunderFrame

Reputation: 9471

Resize your report so that it fits on one page, and set the page orientation of the report to Landscape...

To set the Page layout, goto Print Preview, then click Page Setup on the Ribbon, adjust the page Orientation, and save the report.

Upvotes: 1

Related Questions