Set Print Options

F

FBxiii

Hi.

I have some code to open a query and want to print it out. I know the
command to print (DoCmd.PrintOut) but need to change the paper orientation to
Landscape prior to printing.

Can this be done in code?

Cheers,
Steve.
 
F

FBxiii

Further to my original post. I am still no closer to sorting this out.

Could it have something to do with the Printers collection?
 
S

Stuart At Work

Hi Steve,

To change the orientation to landscape you need the following line of code
before your DoCmd.PrintOut section:

Printer.Orientation = acPRORLandscape

For portrait, the line of code is:

Printer.Orientation = acPRORPortrait

Hope this helps,

Stuart
 
Top