Print page header on every even page only? Conditional print.

  • Thread starter Thread starter Allison
  • Start date Start date
A

Allison

Access 2003 SP 3
Win XP SP2

Is there a way to print my page header on even pages only?

The page header has one bound text box, one unbound text box which
calculates the current date, and one label.

I presume I need to set this section "can shrink"/"can grow" to yes so that
on the odd pages this room isn't reserved (meaning the odd pages start at the
top of the page where the page header isn't).?

Thanks for your help.
 
Access 2003 SP 3
Win XP SP2

Is there a way to print my page header on even pages only?

The page header has one bound text box, one unbound text box which
calculates the current date, and one label.

I presume I need to set this section "can shrink"/"can grow" to yes so that
on the odd pages this room isn't reserved (meaning the odd pages start at the
top of the page where the page header isn't).?

Thanks for your help.
Click to expand...
Showing or Not Showing the Page Header is not a problem.
Code the PageHeader Format event:

Cancel = Me.[Page] Mod 2= 0

Only odd page headers will print.
The problem is, the Page Header (and Footer) do not have a Can Shrink
property, so the space will not be released to the other sections.
 
Access 2003 SP 3
Win XP SP2

Is there a way to print my page header on even pages only?

The page header has one bound text box, one unbound text box which
calculates the current date, and one label.

I presume I need to set this section "can shrink"/"can grow" to yes so that
on the odd pages this room isn't reserved (meaning the odd pages start at the
top of the page where the page header isn't).?

Thanks for your help.
Click to expand...
Showing or Not Showing the Page Header is not a problem.
Code the PageHeader Format event:

Cancel = Me.[Page] Mod 2= 0

Only odd page headers will print.
The problem is, the Page Header (and Footer) do not have a Can Shrink
property, so the space will not be released to the other sections.
Click to expand...

Oops....
Next time I'll attach my fingers to my brain.
The Page Header will indeed release it's space to the next section.
 
Thank you Fred. I am missing part of the equation though.

You said to code the PageHeader Format event - but when I copy/pasted what
you wrote into that field on the properties dialog box and then ran the
report preview, I got an error saying Access can't find a macro called
"Cancel = Me".

Obviously I'm missing something. Please help? Thanks.

fredg said:
Access 2003 SP 3
Win XP SP2

Is there a way to print my page header on even pages only?

The page header has one bound text box, one unbound text box which
calculates the current date, and one label.

I presume I need to set this section "can shrink"/"can grow" to yes so that
on the odd pages this room isn't reserved (meaning the odd pages start at the
top of the page where the page header isn't).?

Thanks for your help.
Click to expand...
Showing or Not Showing the Page Header is not a problem.
Code the PageHeader Format event:

Cancel = Me.[Page] Mod 2= 0

Only odd page headers will print.
The problem is, the Page Header (and Footer) do not have a Can Shrink
property, so the space will not be released to the other sections.
Click to expand...
 
Disregard this please. If I'd read what you wrote...

Anyhow I put this in the CODE instead of an EXPRESSION and it worked just
fine. Thanks.

Allison said:
Thank you Fred. I am missing part of the equation though.

You said to code the PageHeader Format event - but when I copy/pasted what
you wrote into that field on the properties dialog box and then ran the
report preview, I got an error saying Access can't find a macro called
"Cancel = Me".

Obviously I'm missing something. Please help? Thanks.

fredg said:
Access 2003 SP 3
Win XP SP2

Is there a way to print my page header on even pages only?

The page header has one bound text box, one unbound text box which
calculates the current date, and one label.

I presume I need to set this section "can shrink"/"can grow" to yes so that
on the odd pages this room isn't reserved (meaning the odd pages start at the
top of the page where the page header isn't).?

Thanks for your help.
Click to expand...
Showing or Not Showing the Page Header is not a problem.
Code the PageHeader Format event:

Cancel = Me.[Page] Mod 2= 0

Only odd page headers will print.
The problem is, the Page Header (and Footer) do not have a Can Shrink
property, so the space will not be released to the other sections.
Click to expand...
Click to expand...
 
Back
Top