Print page headers/footers only on odd number pages?

[PayeDoc]

Hello All

The subjest says it all: can this be done?

Hope someone can help
Many thanks
Leslie Isaacs

 

[John Spencer]

You can hide the printing, but the space will still be taken up.

You can use code in the PageFooter and Page Header format events like
the code below.

Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As
Integer)
Cancel = Me.Page Mod 2 = 0
End Sub


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[PayeDoc]

John

That's great - many thanks!
I guess it's not possible to free up the space?

Thanks again
Les

 

[John Spencer MVP]

As far as I know, freeing up the space is impossible.

I suspect that you could with some middlin' complicated VBA have a Group
Header print on selected pages and have some controls that would print at the
bottom of selected pages.

Interesting challenge that I don't have time to tackle at the moment.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County