424,294 Members | 1,898 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,294 IT Pros & Developers. It's quick & easy.

Open Report in Landscape

P: 18
I am building a very big, but simple database, with lots of reports. Some of these reports need to open in Landscape, so I change the setting in Page Setup. BUT the next time I open the report it has changed back to portrait! Please, can anyone give me a solution, before I throw my computer out of the window?
May 6 '07 #1
Share this Question
Share on Google+
3 Replies


JConsulting
Expert 100+
P: 603
Have you gone into the menu File > Page Setup... and then the Page tab.
and set your orientation...then saved it? And it comes back portrait when you open it again?
May 6 '07 #2

ADezii
Expert 5K+
P: 8,595
I am building a very big, but simple database, with lots of reports. Some of these reports need to open in Landscape, so I change the setting in Page Setup. BUT the next time I open the report it has changed back to portrait! Please, can anyone give me a solution, before I throw my computer out of the window?
You can set the Orientation Property of the specific Printer assigned to the Report:
  1. Open your Report in Design View.
    Expand|Select|Wrap|Line Numbers
    1. DoCmd.OpenReport "Report1", acViewDesign
  2. Change the Orientation to Landscape.
    Expand|Select|Wrap|Line Numbers
    1. Reports("Report1").Printer.Orientation = acPRORLandscape
  3. Print the Report.
    Expand|Select|Wrap|Line Numbers
    1. DoCmd.OpenReport "Report1", acViewNormal
May 6 '07 #3

P: 1
instead of DesignView, set in the view you can change it which is PrintPreview. I assign this code to a Print button:

DoCmd.OpenReport "YourReport", acViewPreview
Reports("YourReport").Printer.Orientation = acPRORLandscape
DoCmd.PrintOut , , , acHigh

or

DoCmd.OpenReport "YourReport", acViewPreview
Reports("YourReport").Printer.Orientation = acPRORPortrait
DoCmd.PrintOut , , , acHigh
1 Week Ago #4

Post your reply

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