Export to PDF in Lanscape (1 Viewer)

kdog436089

New member
Local time
Today, 13:20
Joined
Oct 16, 2014
Messages
6
Hello Forum,

I am currently trying to export a query to PDF, but I want it to be in landscape. Is this possible? Here is the code that I have so far as well.

Code:
If Not IsNull(displayQuery) And displayQuery <> "" Then
DoCmd.OutputTo acOutputQuery, displayQuery, acFormatPDF, OutputString, True, "", 0, acExportQualityPrint
   Else
     MsgBox ("You Must First Select a Query to Export!")
   End If
End Sub

Any help is greatly appreciated!
 

Minty

AWF VIP
Local time
Today, 20:20
Joined
Jul 26, 2013
Messages
10,355
Have you tried setting your default print/printer layout to landscape?
 

Users who are viewing this thread

Top Bottom