Hide certain report footers and/or control

[tylerg11]

I am using an Access report with a single page footer. I am not using any groupings for totals or anything like that. My report is basically a "two-page report", and I want different page footers for each page. How can I do this with VBA?

I've tried the Page Header/Footer properties, but I'm curious how to do this with VBA because I have more control there. Just want to hide a footer or control within that footer based on the page it is on.

[pbaldy]

You can test like:

If Page = 1 Then

You can hide a section like:

Me.PageHeaderSection.Visible = False