Hide report footer

[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

 

[fredg]

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

Code the Report Footer Format Event:

Cancel = forms!frmMain!SummaryFlag = 0

 

[BoB]

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

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

Code the Report Footer Format Event:

Cancel = forms!frmMain!SummaryFlag = 0