Change PageHeader label's caption on ReportFooter pages...

[ReluctantDataGuy]

Is there a way to change the caption of a label in a report's PageHeader section while the report's ReportFooter section is being formatted/printed?

My report's ReportFooter spans multiple pages.

I want the label in the report's PageHeader section to be different for pages in the report's ReportFooter section. Soemthing like this:

If Not ReportFooter Then
Me.lblSectionTitle = "NormalSection Label Text"
Else
Me.lblSectionTitle = "FooterSection Label Text"
End if

I think the right place to put the above pseudo-code is in the report's OnPage event, but I can't seem to find a way to determine if the page being formatted is in the ReportFooter section of the report.

Any help will be much appreciated!
RDG.