Question Locked

Printing an Access Form in landscape mode

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a Form which acts as a report that I would like to print out. The Form is slightly wider that the standard letter size width (8.5"). I created a command button, which I placed at the bottom of my Form, and in the event procedure for the command button, I used the following code; DoCmd.printout acPrintAll.

The statement prints the Form, but in the defaulted 'Portrait' orientation. I would like to know if there is a way to get the Form to be printed in the 'Landscape' orientation using codes rather than manually going into the print setup to change the page orientation everytime.

3 replies

by ralvarado

yes there is

Forms("Name of your form").Printer.Orientation = acPRORLandscape
DoCmd.PrintOut , 1, 1, acLow, 1, False

This discussion is closed to new replies.