Hiding PageFooterSection on first page only

[Guest]

I used the following code to hide the PageFooterSection of my report on the
first page:

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

When I do this, however, the PageFooterSection is not visible on the second
page, either. What am I doing wrong? Thanks in advance.

 

[Gina Whipp]

Change... Me.PageFooterSection = ([Page] <= 1)

The way you have it says 'anything 1 and greater'

Hope That Helps

 

[Guest]

Thanks, but if I put the "=", the page footer will show on page 1. When I put
the ">" only, the page footer starts on page 3. How do I get it to include
page 2?

Change... Me.PageFooterSection = ([Page] <= 1)

The way you have it says 'anything 1 and greater'

Hope That Helps

I used the following code to hide the PageFooterSection of my report on the
first page:

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

When I do this, however, the PageFooterSection is not visible on the
second
page, either. What am I doing wrong? Thanks in advance.

 

[Gina Whipp]

Oh, my mistake you don't want it to show on page 1

Then Me.PageFooterSection = ([Page] >= 2)

Hope I got it right this time!

Thanks, but if I put the "=", the page footer will show on page 1. When I
put
the ">" only, the page footer starts on page 3. How do I get it to include
page 2?

Change... Me.PageFooterSection = ([Page] <= 1)

The way you have it says 'anything 1 and greater'

Hope That Helps

I used the following code to hide the PageFooterSection of my report on
the
first page:

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

When I do this, however, the PageFooterSection is not visible on the
second
page, either. What am I doing wrong? Thanks in advance.

 

[Guest]

Hi Gina,

I found the answer: Cancel = [Page] = 1

Change... Me.PageFooterSection = ([Page] <= 1)

The way you have it says 'anything 1 and greater'

Hope That Helps

I used the following code to hide the PageFooterSection of my report on the
first page:

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

When I do this, however, the PageFooterSection is not visible on the
second
page, either. What am I doing wrong? Thanks in advance.

 

[Gina Whipp]

Sorry I didn't think of that! Oh, well glad you got that solved....

Hi Gina,

I found the answer: Cancel = [Page] = 1

Change... Me.PageFooterSection = ([Page] <= 1)

The way you have it says 'anything 1 and greater'

Hope That Helps

I used the following code to hide the PageFooterSection of my report on
the
first page:

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

When I do this, however, the PageFooterSection is not visible on the
second
page, either. What am I doing wrong? Thanks in advance.

 

[Rick Brandt]

I used the following code to hide the PageFooterSection of my report
on the first page:

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

When I do this, however, the PageFooterSection is not visible on the
second page, either. What am I doing wrong? Thanks in advance.

Just set the PageFooter property of the report to...

Not with Rpt Hdr

NO code required.

 

[Guest]

This did not work for my report.

Cancel did the trick.

Thanks, though.

I used the following code to hide the PageFooterSection of my report
on the first page:

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

When I do this, however, the PageFooterSection is not visible on the
second page, either. What am I doing wrong? Thanks in advance.

Just set the PageFooter property of the report to...

Not with Rpt Hdr

NO code required.