Set the page orientation for a report using code

[Cindy Lovell]

Is there a way to set the page orientation to landscape
using vb code?

I need my reports to stay in landscape mode and they keep
converting back to portrait. I think it has to do with a
bug in Ms Office 2000 relating to Name Autocorrect. I
really don't want to turn that off. I would prefer to
just add some code on the "On Open" of the report to force
it to be in landscape mode.

Thanks!
Cindy

 

[SA]

Cindy:

Yes there is a bug in A2000, original release, related to the problem you
are having. Stop by the Office web site and update your office install
(http://office.microsoft.com/officeupdate) This problem was corrected with
SR1, but be sure to do all the updates up to SR3 as there are important
patches all the way.

Notwithstanding that, if you stop by our web site in the Code and Design
tips area under reports, you'll find the code you need to set a report's
orientation and paper size at run time (prior to issuing a Docmd.OpenReport)
call.