[AccessD] Add blank page to report via VBA

Dan Waters dwaters at usinternet.com
Fri Jan 22 14:08:59 CST 2010


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




More information about the AccessD mailing list