Page Header On Last Page Only

[leckie]

I need to be able to either enable page header on the last page of a report (because of pre-printed stationary) or insert blank lines. The last page in this instance is always page 4 . . . I have tried to recognise page 4 on the page header format of the page and then make a sub report visible on page 4 but it slips onto page 3 . . any help much appreciated . .

 

[Marryp]

If the last page is always 4 then you can just code it in the format event of the pagefooter. Something like this:

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

If Me.PageNumber <> 4 Then
Me.PageNumber.Visible = False
Else
Me.PageNumber.Visible = True
End If

End Sub