I have a very wide report (14.33"). I need to be able to export the report to PDF and so I am using the below code. However, when I runt he export the report keeps getting spliced like it is a 11.5" x 8.5" sheet. I have tried using page setup and everything, cannot figure out what to do . Help is much appreciated.
Code:DoCmd.OutputTo acOutputReport, "rptRedYellowGreen", "*.pdf", strExportPath & "\rptRedYellowGreen.pdf"