Set the proper paper size....

  • Thread starter Thread starter Alain
  • Start date Start date
A

Alain

Hi again,

I would like to know if it is possible to set the proper pape size
programmatically, meaning I have a report that sometime will need to be
print on 8.5 x 11 (hiden section) and some other time on 8.5 x 14 ( full
blown).
I have look at the help file but no answer

Thanks

Alain
 
Alain:

The problem with your approach, is that if you are attempting to "hide" a
section by reducing the paper width size, that won't work entirely. If you
simply reduce the paper size, Access will still print the controls that you
want to hide, simply on a second page, even if they are set to non-visible
etc., because they occupy space.

Really the only way to accomplish what you are trying to do is to create two
different reports, one with the expanded data and one with the smaller data
set.
 
Back
Top