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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to control report page set-up with VBA?

Status
Not open for further replies.

MatthewsP

Technical User
Feb 19, 2004
4
US
I am using Access 2000, and very often when I open a report in Preview mode, the report has lost its page margin and orientation settings. (For example, I have a report that is supposed to open in landscape and have 0.5 inch margins; about 1/3 of the time it opens in portrait with 1 inch margins.)

I have tried to find a way to use VBA to basically reset the page setup options every time the report is opened (event code), but I have not been able to find the appropriate objects and properties.

Can someone help me figure this out? Or, if not, give me some insight on why the report occasionally "forgets" its page setup settings?
 
I found the answer I was looking for in thread702-560490.

Big thank you to BobJacksonNCI!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top