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").
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A03 - count in report footer gives me #Error? 0
Supress page footer on all but last page. 3
Report - Don't print the page footer on the last page 6
Report Footer 4
Report Footer, multi-column rpt 4
Print objects only on the last page of a report 2
setting "top" of report footer by VBA? 1
Need to print Cover Sheet for report. 11

Back
Top