By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,966 Members | 2,054 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,966 IT Pros & Developers. It's quick & easy.

Read Reports in Landscape

P: 18
Hi Everyone, I have a big database that I am building, very simple, but very annoying. I keep changing certain reports to open in Landscape (by changing the setting in Page Setup) Only to find that the next time I open it it opens in Portrait! Can anyone give me a solution?
May 6 '07 #1
Share this Question
Share on Google+
3 Replies


JConsulting
Expert 100+
P: 603
If you're making change in the page layout and saving them, then those changes SHOULD remain when the report is open again. Are you making the changes while the report is open in design view? If not, you should.
I'm also assuming there's not any kind of code in place to change the orientation at runtime?
May 6 '07 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
You have posted this question in the Articles section. I am moving it to the Access forum.

ADMIN
May 6 '07 #3

ADezii
Expert 5K+
P: 8,628
Hi Everyone, I have a big database that I am building, very simple, but very annoying. I keep changing certain reports to open in Landscape (by changing the setting in Page Setup) Only to find that the next time I open it it opens in Portrait! Can anyone give me a solution?
Try modifying the Orientation for the Printer specifically assigned for the Report:
Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenReport "Report1", acViewDesign
  2. Reports("Report1").Printer.Orientation = acPRORLandscape
  3. DoCmd.OpenReport "Report1", acViewNormal
May 7 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.