Forcing Page size

  • Thread starter Thread starter Patrick
  • Start date Start date
P

Patrick

HI ALL!!

I was wondering if I can force a report,when it opens, to
use legal size paper. I want to write VBA code in
the 'Open' procedure of that report allowing me to do just
that...

Right now, if a user changes its paper size,for what ever
reason, it also affects the other users. so by creating
code for the right size of paper everytime the report is
open, will minimize my chances of printing in the wrong
paper size..

Can it be done, and how?

Patrick

P.S. If there's another way, I open to suggestions.
 
Patrick

Based on your description, I'm guessing that ALL users work from the same
copy of the .mdb file. Either the database is not split, or all users are
pointed at a single "front-end" file. Both of these conditions can result
in corruption issues, and will produce the effect you describe (i.e., one
user changes something, all are affected).

Take a look at Access HELP (and the .tablesdbdesign newsgroup) on splitting
a database, and on front-end/back-end. The general concept is that each
user will have his/her own copy of the front-end, so if s/he wants to change
the printer, s/he can without affecting everyone else.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top