Set default print preview and Print settings for a Query or Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I set a default print preview and Print settings for a individual
Query or Report.

For instance, I have a specific query. When I click on print preview, I
would like to have the print preview automatically show the query in
"Landscape" 8.5 by 14 and be able to print it from there. I can do this
through page setup, but I have to go through the proceedure each time I open
the query. The print preview of the Query always opens in "Portrait" 8.5 by
11 and does not show all the fields.

Please Help,
jbeck2010
 
Open the report in design view.
From the File menu, choose Page Setup.
Choose the orientation and paper size there.
Save the report.

Note that if your default printer does not support this size paper, you will
also need to specify a "Particular Printer" in that dialog, or the settings
may not stick.

If they still do not stick, then you have stuck this bug with Name
Autocorrect:
http://support.microsoft.com/?id=231634
 
Allen,

Thank you for your help. Your proceedure works great on a report.
I was wondering if there was a similar proceedure that would work on a Query.
When I apply the same technique to a Query, save and close the Query, and
reopen it, it reverts to portrait 8.5 by 11.

Do you have any suggestions?

Thanks again,
jbeck2010
 
No. Unlike reports, queries just display data. They are not designed to have
the power of reports, so they just use the default printer's paper size and
orientation.
 
Back
Top