Inserting pages

  • Thread starter Thread starter Paul Billingsley
  • Start date Start date
P

Paul Billingsley

Is there a way to insert a blank page at the end of a report based on page
numbers? What I'm after is to insert a page at the end if I have a odd
number of pages in the report.

Thanks ahead of time...
 
Insert a page break into the report footer, and only make it visible if it's
an odd page number.

Assuming you named your page break control pbOptional, you need code like
this in the Report_Footer Format event:

Me.pbOptional.Visible = ((Me.Page Mod 2) = 1)
 
Thanks for the reply Douglas, That's kinda the first route I took, but
there is no Event (or Visible) when it is placed in the report footer. BTW
I'm using ACC97. Any other thoughts...... I hope?
 
Paul said:
Is there a way to insert a blank page at the end of a report based on page
numbers? What I'm after is to insert a page at the end if I have a odd
number of pages in the report.
Click to expand...


To use the number of pages in a report, you must have a text
box that refers to Pages. Then you can add a PageBreak
control (named pgBreak) to the report footer section and use
a line of code in the section's Format event:

Me.pgBreak.Visible = ((Me.Pages Mod 2) = 1)
 
I'm using Access 97, and I see a ReportFooter_Format event.

You're correct that there is no event associated with the page break control
you added.
 
Back
Top