Display Page footer only once?

[Storm3]

Does anyone have a solution for displaying the page footer only on the first page of a report?

 

[Nouba]

In the page footer's Format event you could try an expression like

Me.Section(acPageFooter).Visible = (Me.Page = 1)

 

[Storm3]

Thank you for your help. Although it was a great suggestion it wasn't working for me. I discovered a way to accomplish this and so far I haven't encountered any bugs with the code.

Private Sub PageFooterSection_Print(Cancel As Integer, PrintCount As Integer)
If [Page] Mod 2 = 0 Then
[Reports]![Proposal].Section(acPageFooter).Visible = True
Else
[Reports]![Proposal].Section(acPageFooter).Visible = False
End If

End Sub

 

[R6Flyer]

Storm3,

Just out of a matter of interest, what happens to the page footer if your report runs over onto 3 or more pages?

Cheers

Flyer

 

[Storm3]

I am currently working on a project that required this and what I have found so far is that the footer only appears on the first page.
The one issue I did find is the if you are putting page numbers in the report you may have issues with the total page count. It seems to add an extra page. The extra page is not visible nor does it print. I am still working on this issue and will advise you on my solution if you'd like.

 

[Storm3]

just when I thought it was solved...

After adding enough data to make the report got over two pages I discovered that the report generates the space for the page footer but does not display it. I have been trying to manipulate the code to adjust for this but to no avail.

Do you think I could make the ffoter draw from another report and set the conditions to be visible only if [Page] = 1 ?

Thanks!