Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change Report Page Settings On Open?

Status
Not open for further replies.

nkrst1

Programmer
Feb 13, 2001
49
0
0
US
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-

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top