Header and Footer turn off for certain page

  • Thread starter Thread starter Anthony
  • Start date Start date
A

Anthony

I have a report that is many pages. I would like to be
able to turn off the header and footer for certain
pages. How can I do this?

Thank you
 
I have a report that is many pages. I would like to be
able to turn off the header and footer for certain
pages. How can I do this?

Thank you
Click to expand...
Which header? Which footer?
In the header/footer Format event:
Cancel = [Page] = ?

replace the ? with the page number.
 
-----Original Message-----
I have a report that is many pages. I would like to be
able to turn off the header and footer for certain
pages. How can I do this?

Thank you
Click to expand...
Which header? Which footer?
In the header/footer Format event:
Cancel = [Page] = ?

replace the ? with the page number.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
Fred,

Thank you. I made it work but only for one page. How do
I turn off header for more than one page? Also, do you
know how to make a different header appear for a certain
page?

Thank you...
 
-----Original Message-----
I have a report that is many pages. I would like to be
able to turn off the header and footer for certain
pages. How can I do this?

Thank you
Click to expand...
Which header? Which footer?
In the header/footer Format event:
Cancel = [Page] = ?

replace the ? with the page number.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
Fred,

Thank you. I made it work but only for one page. How do
I turn off header for more than one page? Also, do you
know how to make a different header appear for a certain
page?

Thank you...
Click to expand...

Regarding: >How do I turn off header for more than one page?<

How would I know? You have given no indication of the circumstances
under which the header/footer should be displayed or not.
Every even page Number?
Cancel = [Page] Mod 2 = 0

I've given you the basics, I'm sure if you think about it you can come
up with your answer.

Regarding:> do you know how to make a different header appear for a
certain page?
When you say a 'different header', perhaps you can make some controls
visible, and others not visible, depending upon some criteria, which
again, you haven't indicated what the criteria should be.

[ControlName].Visible = some criteria = True
[OtherControl].Visible = other criteria = False
 
Back
Top