Hiding PageFooterSection on first page only

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Odniel - 09 Jan 2006 17:01 GMT

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.

Reply to this Message

Gina Whipp - 09 Jan 2006 17:31 GMT

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:
[quoted text clipped - 7 lines]
> second
> page, either. What am I doing wrong? Thanks in advance.

Reply to this Message

Odniel - 09 Jan 2006 17:51 GMT

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)
>
[quoted text clipped - 13 lines]
> > second
> > page, either. What am I doing wrong? Thanks in advance.

Reply to this Message

Gina Whipp - 09 Jan 2006 17:55 GMT

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
[quoted text clipped - 19 lines]
>> > second
>> > page, either. What am I doing wrong? Thanks in advance.

Reply to this Message

Odniel - 09 Jan 2006 18:00 GMT

Hi Gina,

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

> Change... Me.PageFooterSection = ([Page] <= 1)
>
[quoted text clipped - 13 lines]
> > second
> > page, either. What am I doing wrong? Thanks in advance.

Reply to this Message

Gina Whipp - 09 Jan 2006 18:01 GMT

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

> Hi Gina,
>
[quoted text clipped - 18 lines]
>> > second
>> > page, either. What am I doing wrong? Thanks in advance.

Reply to this Message

Rick Brandt - 09 Jan 2006 18:41 GMT

> I used the following code to hide the PageFooterSection of my report
> on the first page:
[quoted text clipped - 6 lines]
> 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.

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

Odniel - 09 Jan 2006 20:17 GMT

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:
[quoted text clipped - 12 lines]
>
> NO code required.

Reply to this Message