Defaults for printing a report? 1

[Wrecker]

Is there a way to set the default on a report to print in landscape? This report is printed from several printers, and everytime I print it, I need to change the settings on the printer.

Thanks in advance
Wrecker

 

[CosmoKramer]

You can do it through Page Setup in Design view, or look up the PrtDevMode property in Access help to set it in VBA.

 

[RikkiC]

PrtDevMode will only work if the database is not being used as an .MDE

 

[bethabernathy]

I am not sure if this is your problem, but there is a bug in Access 2000 which causes the printer settings to revert to the default when the "Perform Name Autocorrect" feature is enabled. To make things more of a pain, the problem only occurs the second time the report is previewed.

This article explains the problem.

Go to the following URL:

http://support.microsoft.com/support/kb/articles/Q240/8/26.ASP?LN=EN-US&SD=gn&FR=0

The quick fix is to uncheck "Perform Name Autocorrect" (Tools, Options, General Tab). The permanent fix is to download Office 2000 Service Release 1/1A (just a small 20mB download).

You'll need to either install the patch or uncheck "Perform Name Autocorrect" on each computer that is used to run the report.

Beth beth@integratedresourcemgmt.com