Printer Settings

P

prhood

I would like to be able to change the printer settings from code, e.g from
"Portrait" to "Landscape". I'm working with some code which opens a query and
I want to print the query results directly with no user input.

My code is as follows:

docmd.openquery acquery, "qryName"
docmd.printout acprintall, , , acdraft

The result typically does not fit on a regular page without changing the
margin settings or orientation. I would like to do so before printing so that
the output is not dependent upon the default print settings.
 
R

Rosco

I might suggest you build a report from your query, and preconfigure the page
setup on the report, that way, you don't have to go through changing setup
each time.

Rosco
 
Top