Dear MS Access Expert.

What is the code for hiding a page footer if the page being displayed is not the last page?

Thank you very much

Peter.

It would seem fairly elementary, but it isn't! If you want the Page Footer to only appear on the last page you have to set the elements in the Footer to Visible=False and then trigger Visible=True on the last page.

If you have something like an Invoice on the Invoice Footer section you set the Page Footer elements Visible=True.

Its sounds a bit daft but the Page Footer does not seem to be able to accept Visible=False

Simon

>>>If you want the Page Footer to only appear on the last page you have to set the elements in the Footer to Visible=False and then trigger Visible=True on the last page.

Yes how do I accomplish this?

Peter

What are you reporting on?

Simon

Purchase Order

Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
Me.txtPages.Visible = (Me.Page = Me.Pages)
End Sub

Try

1) Create a Header and Footer for each Purchase Order.
2) Page Footer controls should be visible
3) Page Header set all Page Footer control to Visible = False
4) Purchase Order Footer set all Page Footer controls to Visible = True

Simon

What is the code for hiding a page footer if the page being displayed is not the last page?

Use the report footer - it only shows at the end.

The problem with the Report Footer is positional. The Page Footer is positioned on the bottom of the page which suits customised stationery.

Simon

The problem with the Report Footer is positional. The Page Footer is positioned on the bottom of the page which suits customised stationery.

Simon

ok, i see. sort of...