Printing problem

[Guest]

I set up a report as landscape orientation but when used by some users, it is
printed as portrait, so everytime one wants to print correctly, one has to
preview the report first and then change it to landscape.

Could you tell me what causes this and how to fix this?

Much appreciated,

Arnon

 

[Allen Browne]

A report can lose its orientation if:

a) The Name AutoCorrect boxes are checked under:
Tools | Options | General
More info:
http://allenbrowne.com/bug-03.html

b) It is opened on a machine that has a different printer driver.

In Access 2002 and 2003, you can set the orientation after the report is
opened, with this code:
Reports![Report1].Printer.Orientation = acPRORLandscape

 

[fredg]

I set up a report as landscape orientation but when used by some users, it is
printed as portrait, so everytime one wants to print correctly, one has to
preview the report first and then change it to landscape.

Could you tell me what causes this and how to fix this?

Much appreciated,

Arnon

If you are using Access 2000 this is a known bug and is documented in
the Microsoft Knowledgebase article:
Q245021 'List of Fixed Problems in Microsoft Office 2000 Service
Release 1/1a (SR-1/SR-1a)'
And specifically:
Q240826 'Lost Printer Settings when Name Autocorrect is turned on'

Turn off the Name AutoCorrect feature as a temporary 'fix'.
Then download and install the Service Release 1/1a.