Easy one - landscape vs portrait

X

xyz

How do I save a query so that it always prints in landscape format.
Currently I have to go to page setup each time and change from portrait to
landscape before printing.

Thanks.
 
R

Rick Brandt

xyz said:
How do I save a query so that it always prints in landscape format.
Currently I have to go to page setup each time and change from portrait to
landscape before printing.

You can't. Use a report that "looks" like the query grid and then you can.
 
V

Van T. Dinh

Sorry, you can't save Page Setup with DatasheetView of the Query.

You need to create a Report which can look like a Datasheet and then specify
the Page Setup for the Report.
 
J

John Vinson

I guess it's NOT an easy one.
It's not, because a Query is not an appropriate tool for printing.

Create a Report based on your query; set its landscape/portrait as
desired; save the report.

The Report will remember how it's to be printed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top