Printing to the right tray

[Luke Bellamy]

Hi - we are using a printer that has a tray for A3, A4, and letterhead.
The reports I'm printing in Access 2002 are designed for A4.

It seems that if you print a report in Excel to A3 and then open the
Access database a print a report it goes to the A3 tray (i.e last one
printed to).

So my question is, should I set the paper size to A4 or set the bin
to Auto (or both) to get this to print to the correct tray? I mean set
these properties on the Application.Printer object.
Other customers use this database so I don't want to hard code anything
to say "always print to tray 1".

Any hits would be appreciated.

Thankyou,
Luke

 

[Arvin Meyer [MVP]]

A printer in Windows is nothing more than a device, not a physical piece of
hardware. Thus a physical printer, can be configured to many different
Windows "printers". What I would do is build a "printer" that uses only A4
and set that as the default printer. Build another for A3 and change to that
as a specific (not default) printer when printing to Excel. You can reverse
that process and use that as a specific printer in Access. Open each report
in design view set the printer and save the report.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access