Force a blank page

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

I have an application wherein I need to force a
blank page, sometimes at the beginning of the
report and sometimes at the end. How do I
do that?

Bill
 
The same report or different reports?

You could include a page break control and turn its visible property on and
off with some vba.

Another method would be to use a blank Report Header (not the page header)
and force a page break after the Report header section.
If your report is not using the Report footer you can force a page break
after the Report footer.

Also, do you mean completely blank (no page header or page footer) or do you
mean no data between the two items.
 
John wrote:
Another method would be to use a blank Report Header (not the page header)
and force a page break after the Report header section.

How does one do that? In the ReportHeader_Format? ReportHeader_Print?
Whichever the case, I don't see a command in the VBA help for that?

By blank page, I mean "like" one was going to put a separator page between
multiple copies of a printed report.
Bill
 
Add a report header to the report
Set the Report Header's Force New Page property to After Section (on the format tab)

If you have page header and footer sections with controls that print you will
probably have to hide the controls when you are "printing" this page. That may
require vba code to run that checks the page number (Page) and hides or shows
the controls depending on the current page number.
 
Back
Top