Only show page footer on first page

[Guest]

Hi,
Anyone know of a way to get a report's page footer to only show on the first
page?

Thanks

 

[Rick Brandt]

Hi,
Anyone know of a way to get a report's page footer to only show on
the first page?

Thanks

You can put code in the Format event of the section...

Cancel = (Me.Page > 1)

....but I think that will still show a blank space where the footer would
ordinarily be.

 

[Guest]

Hi

Put this is the "page header" OnFormat event

Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As
Integer)
Me.Section(4).Visible = Me.[Page] = 1
End Sub

 

[Guest]

Yay! That worked like a charm. Thanks!

Hi

Put this is the "page header" OnFormat event

Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As
Integer)
Me.Section(4).Visible = Me.[Page] = 1
End Sub


--
Wayne
Manchester, England.

Hi,
Anyone know of a way to get a report's page footer to only show on the first
page?

Thanks

 

[Dev]

Hi,
I have a similar issue as Adna and I tried your solution. It sort of worked
for me, but perhaps you could assist me further with more specifics?

My issue: I have a report that has a Detail Section that can grow. I have
set up Signature lines to appear in the Footer and I would like it to show up
on the last page of the report...whether it is 1, 2, or 3 pages long. Do you
know how i might set that up?

I appreciate any assistance you can provide.

Thanks,
Dev

Hi

Put this is the "page header" OnFormat event

Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As
Integer)
Me.Section(4).Visible = Me.[Page] = 1
End Sub


--
Wayne
Manchester, England.

Hi,
Anyone know of a way to get a report's page footer to only show on the first
page?

Thanks

 

[adna]

Hi Dev,
Not sure if this will work for you but perhaps you could just add your
signature lines in the report footer instead of the page footer. That way it
will only appear on the last page of the report.

Hi,
I have a similar issue as Adna and I tried your solution. It sort of worked
for me, but perhaps you could assist me further with more specifics?

My issue: I have a report that has a Detail Section that can grow. I have
set up Signature lines to appear in the Footer and I would like it to show up
on the last page of the report...whether it is 1, 2, or 3 pages long. Do you
know how i might set that up?

I appreciate any assistance you can provide.

Thanks,
Dev

Hi

Put this is the "page header" OnFormat event

Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As
Integer)
Me.Section(4).Visible = Me.[Page] = 1
End Sub


--
Wayne
Manchester, England.

Hi,
Anyone know of a way to get a report's page footer to only show on the first
page?

Thanks