Sorry, nothing comes to mind.

I thought about using the page number with Mod 2 and using that to print the
terms page, but that would probably fail since you have a sub-report printing.

Something like
Private Sub Report_Page()
If Me.Page Mod 2 = 0 Then
Me.txtTerms.Visible = True
Me.cPageBreak.Visible = True
Else
Me.txtTerms.Visible = False
Me.cPageBreak.Visible = False
End If
End Sub

Perhaps ;you can find a way to redesign the report so it is not using a
sub-report. It is often possible to get the same printout results using
grouping and sorting instead of using a sub-report.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Brian Hawks wrote:
That would work, but only for the end of each invoice. I should have clarified that I need the terms and conditions to be printed behind EACH page of the invoice. That is why I was assuming I would have to put something in the detail section, since it is the section that is creating the new pages. Any other ideas I could try?



John Spencer wrote:

You might try adding a group based on the invoice number and put the Terms
06-May-10

You might try adding a group based on the invoice number and put the Terms and
Conditions in the group footer. Set the group footer to print on a new page
by setting Force New Page property to Before Section.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Brian Hawks wrote:

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Crypto Obfuscator for .NET - Product Review
http://www.eggheadcafe.com/tutorials...or-for-ne.aspx