Stop page headers printing on report footer

[John Baker]

Is there a way of stopping the printing of the page headers on the page that
has the report footer. The report footer appears on the last page by
itself.

Any help greatly appreciated.

John B

 

[Brendan Reynolds]

Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As
Integer)

If [Page] = [Pages] Then
Me.PageHeaderSection.Visible = False
End If

End Sub

 

[fredg]

Is there a way of stopping the printing of the page headers on the page that
has the report footer. The report footer appears on the last page by
itself.

Any help greatly appreciated.

John B

Set the Report's Page Header property to
Not with rpt footer
It's located on the Report property sheet Format tab.
The default is All Pages.