Change Page Setup for a Report On Open?

[nkrst1]

I would like to check and conditionally change the Page Setup of a report when it opens. How would I do this in the On Open Event?

I basically want to change these settings:

Left, Right, Top, Bottom Margins
Orientation of Page
Basically all Column Data, Number, Row/Col spacing, Column Size, Column Layout.

I'm trying the Application.GetOption function in an On_Open event, but I can't seem to find the right variable... Default Column Width just gives me the default, but I want the current setting for this report...

Any help is much appreciated.

Thanks,

-n-

 

[jjonesal]

Try using the Me.Printer object and its properties.... J. Jones
jjones@cybrtyme.com

 

[nkrst1]

Thanks but,

Me.Printer is not recognized

Me.Print prints the report.

-n-