[AccessD] Page printing problem

Doug,

    You could try the following code in report footer's format event:

' Code in report's module:
'=============================
Private Sub ReportFooter_Format( _
                            Cancel As Integer,  _
                            FormatCount As Integer)
    If Me.Page Mod 2 > 0 Then
        Me.ReportFooter.ForceNewPage = 1
    Else
        Me.ReportFooter.ForceNewPage = 0
    End If
End Sub
'=============================

Best wishes,
A.D. Tejpal
------------

  ----- Original Message ----- 
  From: Doug Steele 
  To: Access Developers discussion and problem solving 
  Sent: Thursday, July 26, 2012 23:27
  Subject: [AccessD] Page printing problem


  Hello All:

  I need to force a report to always print an even number of pages - if
  the page count is odd, print a blank page at the end.  I tried putting
  a dummy report footer on a new page, and cancelling it if the page
  count is even, but cancelling the footer still leaves a blank page
  there.

  Mr. Google doesn't have any information.  Any suggestions?

  Thanks,
  Doug