Access 97 Legal size

[Guest]

I have several reports that are designed for legal size printing. I am using
Access 97. It seems when printing they revert to standard size. Therefore I
have to go into the page set up every time a user prints the report and
change it to landscape. Is there any VB code I can use to automate this
process?

 

[SA]

M:

The issue in reverting to portrait / letter paper size is common if the user
either 1.) selects to print from a previewed report and changes the printer
(where the report will revert to the new printer's default layout.) or 2.)
if the report is set to use a specific printer, but that printer is not
available on the users machine.

Normally the best work around is to eliminate the Print option from the tool
bar and menu associated with the report (by creating custom tool bars and
menus and specifying them in the report's properties) and then on the form
which calls the report, setting separate preview and print buttons, where
the latter uses simply the docmd.Openreport method to print the report from
a closed situation. If the report is set to use the default printer, then
printing in this manner should preserve the layout.