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

[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.

 

[fredg]

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.

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.

 

[fredg]

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.

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.

Oops....
Next time I'll attach my fingers to my brain.
The Page Header will indeed release it's space to the next section.

 

[Allison]

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.

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.

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.

 

[Allison]

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.

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.

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.

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.