That would work, but only for the end of each invoice.
in [Reports]
|
From: Brian on 6 May 2010 16:05 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/aspnet/bf15c41b-6510-403e-9af8-f5fd987fafb1/crypto-obfuscator-for-ne.aspx
From: John Spencer on 9 May 2010 11:15 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/aspnet/bf15c41b-6510-403e-9af8-f5fd987fafb1/crypto-obfuscator-for-ne.aspx
|
Pages: 1 Prev: Criteria for an email address field Next: Missing information when filtering |