Print page footer only on the first page

[Akai90]

hi,

i have some text in footer section but i want to show only page 1 and hide on page 2

on print preview it got like what i want but when print the report on footer text not show anything..

the code i use

Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
Me.PageFooterSection.Visible = (Me.[Page] = 1)
End Sub

Private Sub PageFooterSection_Print(Cancel As Integer, PrintCount As Integer)
Me.PageFooterSection.Visible = (Me.[Page] = 1)
End Sub

 

[Ranman256]

These work for me.
only page 1 shows the section data.

  'PAGE FOOTER
Private Sub PageFooterSection_Print(Cancel As Integer, PrintCount As Integer)
Me.PageFooterSection.Visible = (Me.[Page] = 1)
End Sub

 

[Akai90]

These work for me.
only page 1 shows the section data.

  'PAGE FOOTER
Private Sub PageFooterSection_Print(Cancel As Integer, PrintCount As Integer)
Me.PageFooterSection.Visible = (Me.[Page] = 1)
End Sub

for print preview it work... when i hit print button no value on "PageFooterSection" print

 

[Akai90]

Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
Me.PageFooterSection.Visible = (Me.[Page] = 1)
End Sub

problem solved
remove above code use only

Private Sub PageFooterSection_Print(Cancel As Integer, PrintCount As Integer)
Me.PageFooterSection.Visible = (Me.[Page] = 1)
End Sub

 

[gemma-the-husky]

I'm not saying it is this, but if you preview, and then print, counters don't always reset to zero. so you might not be getting a page 1 when you print. Get your code to display the pageno to check.