how can I have a report print to a specific printer and paper tray (paper
size of 11 x 17) whenever the report is printed

Open the report in Design view
-- Select File: Page Setup
-- Click on the page tab
-- Check Use Specific Printer
-- Click on Printer button
-- Choose a printer from the list (or click on Network button to choose a
network printer that is not set up in the list)
-- Click the Properties button to set up page sizes and other printer options
-- Click the OK buttons


John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

neenmarie wrote:
> how can I have a report print to a specific printer and paper tray (paper
> size of 11 x 17) whenever the report is printed

Thank you so much for the detailed help. I appreciate it

"John Spencer" wrote:

> Open the report in Design view
> -- Select File: Page Setup
> -- Click on the page tab
> -- Check Use Specific Printer
> -- Click on Printer button
> -- Choose a printer from the list (or click on Network button to choose a
> network printer that is not set up in the list)
> -- Click the Properties button to set up page sizes and other printer options
> -- Click the OK buttons
>
>
> John Spencer
> Access MVP 2002-2005, 2007-2008
> Center for Health Program Development and Management
> University of Maryland Baltimore County
>
> neenmarie wrote:
> > how can I have a report print to a specific printer and paper tray (paper
> > size of 11 x 17) whenever the report is printed
>

Thank you so much for your help! After so many headaches and much lost time with playing around with those settings it finally works!
Once again thank you very much,
Nate