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

Access Reports - Page Setup Options Don't Save with Report

Status
Not open for further replies.

AccessUser22

Technical User
Jan 23, 2003
168
US
I have tried to figure this one out for awhile, and maybe it's something simple or just a bug? When I set my report's page layout details (landscape, margins) they are supposed to be saved so that when I re-open the report in the future, the layout will automatically be set. However, this only seems to work for me about 50% of the time. Would this have something to do with how I open my reports? I currently am using:

DoCmd.OpenReport stDocName, acPreview

Is there anyway to set these properties through code? It would be nice to be able to have these reports open properly so that the user doesn't have to go in and set this all the time.
Any info/ideas are appreciated. Thanks.

[ponder]
 
It's a bug in Access 2000. Either apply the latest service packs or menu select Tools|Options and un-check all of the Name Autocorrect boxes.

Duane
MS Access MVP
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top