Read Reports in Landscape

jennyp29

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?

JConsulting

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?

msquared

You have posted this question in the Articles section. I am moving it to the Access forum.

ADMIN

ADezii

Quote:

Originally Posted by jennyp29

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

 DoCmd.OpenReport "Report1", acViewDesign

Reports("Report1").Printer.Orientation = acPRORLandscape

DoCmd.OpenReport "Report1", acViewNormal

Read Reports in Landscape

re: Read Reports in Landscape

re: Read Reports in Landscape

re: Read Reports in Landscape

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about