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
Re: Microsoft Access Report Page Orientation
Welcome to the Forums.
You can set the printer objects Orientation property to landscape.
VB Code:
Me.Printer.Orientation = acPRORLandscape
Re: Microsoft Access Report Page Orientation
Thanks RobDog888,
It worked. :thumb:
*k
Re: Microsoft Access Report Page Orientation
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?
Re: Microsoft Access Report Page Orientation
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:
Re: Microsoft Access Report Page Orientation [Resolved]
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.