PAGE SIZE

  • Thread starter Thread starter frank
  • Start date Start date
F

frank

I've posted this question before, however the solution
didn't work. Everytime i open a report I've formatted
legal it opens letter & I have to change the size in page
setup.
Someone daid this is a bug in 2000 and to turn off
autocorrect, this didnt work.
Does anyone know a way to write some VB to change the page
size to legal everytime the report opens? Or any other
solutions would help. By the way its Access 97

Thanks
 
I've had the same problem with a report created in Access
2000. This report was in a multi-user database being run
by several workstations. I did a lot of research and
testing regarding this problem and didn't really get a
firm answer as to what was causing the problem.

My problem went away when I split the database into a
Front End / Back End setup. Once this was done, I placed
a Front End database containing the reports on each
machine. I did the page setup for the legal report on
each machine (one time) and from that point on, each time
any of the workstations printed the legal report it
printed OK without any problems.

I have noticed that if I open the report in design view on
a different workstation from where the report page setup
was saved with the legal layout, the report will have
defaulted back to letter page size.

This tells me that there is some specific printer/page
setup information that Access stores on each machine for
the reports and when it cannot find this information it
resorts back to the default page settings for the printer
which is usually letter size paper.

I'm sure your problem is related to the above.

This really needs to be corrected. The page setup for a
report should only have to be addressed one time.

Hope this helped.

ET Sherman
 
I have the same problem but reverse paper size. System is in A97 with data
on server and mde on each workstation. Client is a mortgage company and all
printers have a default paper size of legal. All reports in the system are
legal size except for one that prints labels which need to have standard
letter size. That report keeps reverting to the legal size paper and
therefore creates a problem if user forgets to change paper size when
printing. I have searched the KB and Google and can't find an Access
solution. The only thing I can think of is to change the default printer's
paper size prior to printing the report and changing it back after. Seems
like a bit of overkill for something that should not be happening.
I am also surprised that one of the MVPs don't have something to say on the
subject.
If you find a solution, I would appreciate you sharing it with me.
 
Back
Top