JJ:
You don't specify which version of Access you are using but if you are using
Access 2000, then be sure that you've applied Service Release 1 to all
installations. Secondly, the problem you are describing can occur in all
versions of Access under the following circumstances:
1.) If a report is specified to use a specific printer (say a network
printer) and that printer is not available on the local user's machine, then
the report will revert to using the default printer and also will reset the
layout.
2.) If the user previews the report and then changes the printer target by
using File-> Print. When the new printer is selected in this manner the
report will load that printer's default paper layout (normally portrait /
letter or A4). This is unfortunately by design.
To work around these issues, normally you'd want to have all reports set to
use the default printer. Then when the user previews the report, it will
retain the layout you've specified using the default printer. (The same
issue will pop up if the user THEN changes the printer from preview.) If
the user needs to switch printers, then its best to change the default
printer (using the windows default for Access 97/2000, and the application
default for Access 2002 and 2003) while the report is closed by giving the
user a printer selector combo box on the forms where the report is to be
printed from. There's lots of places to pick up code to set the default
printer.
If you want code that will change paper layout / size etc. You can find that
on our web in the Code and Design tips area under the Reports subsection.
If you want a full code solution to managing printing, printers layout etc
for Access Dbs, then look in the Developer Tools area of our web at our "On
the Fly Printing" solution.
