Access: remember print settings (1 Viewer)

[steallan]

HI

If i set the print settings (page orientation, size etc) when i have a query open, Access has forgotten it next time i open the query.

How the smeg do i get it to remember the print settings?

Please help me im running out of hair!

Thanks

 

[spacepro]

This is what is says in the Help File.

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, data access pages, and modules, you must set page setup options every time you print.


Regards
Andy

 

[steallan]

Well isn't access a bag of $hit!

when it comes to printing anyway

thanks Andy at least thats resolved, ill export to excel i guess

 

[Rich]

Reports are designed for Printing, the fact that you're not using the correct tool for the job doesn't make Access a bag of shit.
Using the Report wizard to create a report will be far more useful than having to export to XL, and far quicker