Supress printing of an "overflow" page

  • Thread starter Thread starter AlBear
  • Start date Start date
A

AlBear

We use Access to print checks on pre-printed forms. (Access 2007 with an
Access 2003 mdb in compatibility mode.)

Normally all of the detail for the check stub fits on a single page, but it
is possible that there could be too many detail lines with the result that
the sub-report for the stub detail would get too long and cause Access to
print 2 pages for a check instead of 1. This would make all the subsequent
check numbers off by 1.

Is there a way I can use VBA to capture that and supress printing of the
"overflow" page?

Thanks.
 
can you control that field - or possibly section or subreport - using the
'Can Grow' set to No : property??
 
Back
Top