Printing report footers 1

[Moss100]

I am printing a report as my letterhead.

I have made my logo as the report header and my address as my page footer. The problem with this is that I get my address appearing on the bottom of the following pages and I just want it to appear on the front page.

Is it possible to just make the page footer print on the first page???

Thanks for any help or suggestions

Mark

 

[Tranman]

Mark,
You should be able to create a global variable:

Public myVar as String

and set it to something like "Y" in the Report Open Event, then in the Print Event of the footer, say something like:

If myVar = "N" then Cancel = True
myVar = "N"

So you will print the footer the first time through, then every subsequent time, myVar will = "N" and printing of the page footer will be Cancelled.

Good Luck,
Tranman

"Adam was not alone in the Garden of Eden, however,...much is due to Eve, the first woman, and Satan, the first consultant." Mark Twain

 

[mp9]

It's a bit naughty posting the same question in multiple forums. Still, here's the answer:

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

 

[Moss100]

I have pasted

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

into the On Print property of the Page Footer - and it just starts the debugger. Any ideas?

 

[Moss100]

Thanks - it's all workinhg great now