[AccessD] Add blank page to report via VBA

Hello Dan,
Thanks for the response.
Lambert's solution is just fine.
Maybe I will try yours when I get a chance.

Bob Heygood
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Friday, January 22, 2010 12:09 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Add blank page to report via VBA

Try placing textboxes where you might want blank pages.  I believe in the
format event you can manage the height of those textboxes, and force a blank
page, with accurate page numbering.  Set the border for the textbox to be
white.

I've never done this, but Good Luck!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob Heygood
Sent: Friday, January 22, 2010 1:49 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Add blank page to report via VBA

Hello to the list,

My current project requires me to print a report that contains 5 subreports.
The fourth sub can grow to sometimes 4 or more pages.
Depending on the amount of pages for the above sub, I need to insert enough
blank pages between them and the last sub so that the total amount of pages
for the whole report equals a multiple of 4 (4, 8, 12.......).
This is necessary to allow the whole job to be sent to ClickBook and have
the last page be on the back of the resulting booklet.
Access 97
I note there is "ForceNewPage" in A2K and later, not useful to me using A97.

Extra points for allowing me to print accurate page numbers for all pages
starting with sub 2 and ending at the end of sub 4.

TIA

Bob Heygood

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com