I want to print my report on legal paper, but it defaults to letter 1

[ruthcali]

i am using Access97 in a Novel environment.<br><br>i have a report that should be viewed and printed on legal paper (if not, the report ends up being two pages instead of one). <br><br>i keep going to file, page setup and chosing Legal for paper size.&nbsp;&nbsp;but somehow, next time i open the database, it defaults back to letter size.<br><br>is there a way (programmatically?) to force a report to be on legal paper all the time?<br>

 

[DougP]

See my FAQ on Printers<br><br><A HREF="

http://www.tek-tips.com/faq.cfm?spid=181&page=1&CFID=3407510&CFToken=86800651#14"

TARGET="_new">

http://www.tek-tips.com/faq.cfm?spid=181&page=1&CFID=3407510&CFToken=86800651#14</A>

<p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[Guest_imported]

My guess is this is not a report but you are printing a query. If you create a report based on the query and save the options it will always print to the options you have saved. You can make the report look exactly like the query.<br><br>Microsoft Access stores the settings for page setup options with a form or report, so you set these options only once for each form or report. For tables, queries, and modules, you must set page setup options every time you print.