Landscape vs Portrait

[bevnz]

Hi All

I have a problem with reports that were designed in
landscape reverting back to portrait in preview and also
when they are printed. The landscape reports page setup
was set to landscape with all margins set at the time of
design. The properties sections of each report have been
set to CanGrow = "Yes", CanShrink = "Yes".

I want to add vba code that will change the orientation to
landscape before the PrintPreview and/or Print command
line executes. I know how to do this in vb but I've had no
luck in vba.

Does anyone know what code is needed?

Here's what I'm using;

Dim stDocName As String

DoCmd.MoveSize 0, 0, 0, 0
stDocName = "Closed Estimator"
DoCmd.OpenReport stDocName, acPreview

The MoveSize line just shrinks the dialog box before the
report preview.

Thanks for any direction.

Bevnz

 

[Duane Hookom]

Why not just fix the problem. Access 2000 may change the report properties
back to default values unless you have the latest service pack applied. You
can also select Tools|Options and uncheck all NameAutocorrect boxes.

 

[Guest]

I looked in the options and didn't see anything about
NameAutocorrect.

The database is being used by a client with several
locations using many different printers. I want to add the
code at the module level to eliminamte the employees's
having to understand how to download and install the
service packs.

It is an additional step for them to change the page setup
evertime they preview or print a report.

Also, the databse is distributed with Access runtime only
and I'm not sure if the service packs will help.