print with Landscape orientation

[Guest]

Hi,
I create a command button which print a table. But I want to print this
table in landscape orientation. In the code of the button I add:

Printer.Orientation = acPRORLandscape,

but it doesn't work. There's no error, but the printer orientation is still
portrait.
Thanks in advance.

 

[Guest]

Sueprnaut,

I typed the following into the immedate window:

Application.Printer.Orientation = acPRORLandscape

then printed a table (right-click, print) and it printed in landscape mode.

If you put that code into your click event, I believe it will work.

Bruce