printing report preferrences

[Bill]

OK, I have several reports that I print out on 8.5 x 14 landscape and then I
have several reports I need to print on 8.5 x 11 portrait. How do I code
that.

I can only find one way of doing it and that's in Page Set up which means
the user has to make that adjustment. I want to make that adjustment in the
code depending on the report that user has choosen.

Any help getting this sorted would be greatly appreciated.

Bill

 

[Marshall Barton]

OK, I have several reports that I print out on 8.5 x 14 landscape and then I
have several reports I need to print on 8.5 x 11 portrait. How do I code
that.

I can only find one way of doing it and that's in Page Set up which means
the user has to make that adjustment. I want to make that adjustment in the
code depending on the report that user has choosen.

If you use PageSetup when the the report is in design view,
then the orientation and paper size will be saved with the
report. This way you don't need any code or user
interaction to get what you want.

If you have some other need to change these settings, you
can (A2003 or later) try using the Printer object in the
report's Open event procedure.

 

[Bill]

Thank you

I figured there would be a simple solution.

Bill