Hide report footer

  • Thread starter Thread starter BoB
  • Start date Start date
B

BoB

Touching up a report by adding a checkbox on a main form to specify whether
to display a summary report in the report footer.

' Show or Hide Report Summary
If [Forms]![frmMain]![SummaryFlag] = 0 Then

Me!rptIVSummary.Visible = False
Else
Me!rptIVSummary.Visible = True
End If

It works great exept I now left with a blank last page where the report
would have shown. How can I hide the complete footer rather than the
report?

thanks
 
Touching up a report by adding a checkbox on a main form to specify whether
to display a summary report in the report footer.

' Show or Hide Report Summary
If [Forms]![frmMain]![SummaryFlag] = 0 Then

Me!rptIVSummary.Visible = False
Else
Me!rptIVSummary.Visible = True
End If

It works great exept I now left with a blank last page where the report
would have shown. How can I hide the complete footer rather than the
report?

thanks
Click to expand...

Code the Report Footer Format Event:

Cancel = forms!frmMain!SummaryFlag = 0
 
Thanks Fred,

Almost worked ;-) Easier way to suppress the footer but my report still
adds the last page with nothing but the main report 'page footer'.
I set the Page Header property = Not with Rpt Ftr, and Page Footer property
= All pages

How can I dump the last page?

Again thanks for your suggestions

Dave

fredg said:
Touching up a report by adding a checkbox on a main form to specify whether
to display a summary report in the report footer.

' Show or Hide Report Summary
If [Forms]![frmMain]![SummaryFlag] = 0 Then

Me!rptIVSummary.Visible = False
Else
Me!rptIVSummary.Visible = True
End If

It works great exept I now left with a blank last page where the report
would have shown. How can I hide the complete footer rather than the
report?

thanks
Click to expand...

Code the Report Footer Format Event:

Cancel = forms!frmMain!SummaryFlag = 0
Click to expand...
 
Back
Top