Report Not Maintaining Page Setup

  • Thread starter Thread starter ET Sherman
  • Start date Start date
E

ET Sherman

This post is in reference to the problem in Access 2K not
maintaining the page setup information, especially the
page orientation to landscape and page size to legal.

I have seen several responses saying this is corrected
with service pack SR1a and to turn off the Auto Correct
feature but I don't find this to be true.

I have had this problem for a long time and it seems like
Access saves some report printer page setup information
with the database on the machine where the report is being
saved after changing the setup information.

Example: I have a legal landscape report setup in a front
end / back end database setup. If I change my default
printer to another printer and print the report it will
reset to letter and potrait. I can do the page setup and
change it back to letter landscape and it will print ok
everytime until I make some type of change to the default
printer. Likewise, if I send the front end database back
to a client after changes were made, the report will
default back to letter potrait. Once they do the page
setup on their machine and change the settings to
landscape legal, the report prints ok everytime with on
problems.

SR1a has long been installed on my machine as well as the
client's machine to no avail.

This confirms that it has something to do with the printer
information being saved with the report.

If anyone knows how to truely correct this I would
appreciate your input.

Thanks,

ET Sherman
 
ET:

You are talking about two different problems here.

1.) The fix regarding not maintaining page set up info is correct, either
disable Name autocorrect or apply SP1.

2.) The other issue about changing printers is normally only impacted only
if you haven't set the report to use the default printer via the radio
button on File -> Page Set Up -> Page tab, or if you, while in Print
Preview, chose Print and then switch printers in the Print dialog. What
occurs in these situations, is that when the new printer is selected, Access
reads the default printer settings, which in most cases are portrait, letter
size paper and sets those into the report, overwriting previous settings.
This "issue" has been around since Access 1.x.. The work around is to set
the report to use the default printer and to change the default prior to
printing.
 
Hello Steve,

Thanks for the response but as far as your comment
regarding comment #2, the reports are always set to use
the workstation's default printer and it is not because
the printer was switched after print preview.

As previously mentioned below, I have spent many hours
researching this problem to no avail.

I can have a client send me their front end database and
without doing anything to my printer setup the first time
I run a legal landscape report it will default to letter
potrait. The same will happen when I send the database
back to the client. This should not happen.

At the client's site, a workstation can have more than one
printer set up, say LaserJet1, LaserJet2 and LaserJet3.
If a user is told that their default printer LaserJet1 is
down and to change their default to LaserJet2 "before even
opening the Access database", the legal landscape reports
will not print correctly the first time.

This is a problem for clients in that its hard for them to
understand why the report will not maintain the page setup
and you can take a spreadsheet that has been setup for
landscape legal, change printers, email it or whatever and
this will not happen.

It just makes your application look bad when this
continuously happens. Microsoft really needs to correct
this.

Thanks,

ET Sherman
 
Back
Top