Microsoft Access Report Page Orientation [Resolved]

Hi,

I have a number of reports on my MS Access project.

One of them I need it viewed in landscape, but although I have changed it to landscape in design mode, when viewed it goes back to potrait.

How can I set it dyanmically "On Open" to display in orientation mode.


Thank you in advance!

*k

Welcome to the Forums.

You can set the printer objects Orientation property to landscape.

VB Code:

Me.Printer.Orientation = acPRORLandscape

Thanks RobDog888,

It worked. :thumb:


*k

You can also change the page setup via code but not upon opening the report the first time. This way when the user views the
report it will be representative of the printout?

Quote:

---

Originally Posted by RobDog888

You can also change the page setup via code but not upon opening the report the first time. This way when the user views the
report it will be representative of the printout?

---

I do not understand. Will you please show me more.
:confused:

Doh! Nevermind. I'm still waking up this morning. If your page dimensions are already 11 x 8.5 then your already in landscape.
I was thinking of Page Setup where you can change the orientation.