Conditional Report Footer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report where if an option box value is 1 then it prints the footer
(which is two pages long) otherwise it does not print the footer. My problem
is that when it does not print the footer, I get a blank page. This has
nothing to do with margins or page breaks (there is no problem if the footer
prints). Here is the code from the OnFormat event of the report footer.


If Forms!frmQuote!PrintContract = 2 Then
ReportFooter.Visible = False
Else
ReportFooter.Visible = True
End If


Any help would be greatly appreciated.
 
Not sure if it will work, but you could try setting the report's runtime
properties PrintSection and MoveLayout to No instead of setting the Visible
property.

Programmatically hiding the report sections can have some interesting side
effects (e.g. "Page 8 of 7").
 
Back
Top