Connecting Tech Pros Worldwide Forums | Help | Site Map

Open Report in Landscape

Newbie
 
Join Date: Sep 2006
Posts: 18
#1: May 6 '07
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?

JConsulting's Avatar
Expert
 
Join Date: Apr 2007
Location: Houston
Posts: 601
#2: May 6 '07

re: Open Report in Landscape


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?
ADezii's Avatar
Expert
 
Join Date: Apr 2006
Location: Philadelphia
Posts: 5,226
#3: May 6 '07

re: Open Report in Landscape


Quote:

Originally Posted by jennyp29

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
Reply


Similar Microsoft Access / VBA bytes