Print page headers/footers only on odd number pages?

  • Thread starter Thread starter PayeDoc
  • Start date Start date
P

PayeDoc

Hello All

The subjest says it all: can this be done?

Hope someone can help
Many thanks
Leslie Isaacs
 
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
'====================================================
 
John

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

Thanks again
Les
 
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
 
Back
Top