Define margin in a report

  • Thread starter Thread starter John Smith
  • Start date Start date
J

John Smith

Hi everyone,

His there a way to programm in VBA the margin of a document (Top, left,
right, ...)?? My probleme is often, the margin goes back to 24.99 and my
report is all messed up

Thanks

John!
 
John Smith said:
Hi everyone,

His there a way to programm in VBA the margin of a document (Top, left,
right, ...)?? My probleme is often, the margin goes back to 24.99 and my
report is all messed up
Click to expand...

There are two common reasons for a margin to not "stick" when you set it in Page
Setup. One is a common bug in Access 2000. This causes all page settings to
revert to the defaults. The fix is to apply all of the Service Releases for
Office 2000, but turning off Name - Autocorrect is a workaround.

The other is if you are attempting to set the margin beyond the limits of your
printer driver. You simply cannot do that. That issue can be directly seen in
the Page Setup dialog. If you enter a zero in any of the margin settings and
then Tab out, it will immediately change to the minimum allowed setting for the
driver. As long as your setting in the dialog doesn't immediately change when
you tab out, then you are likely dealing with the aforementioned bug.
 
Back
Top