Set page footer height after first page

[Guest]

I want to print a small picture in the page footer of my report on page 1
only. I can set the object visible on page one only, but the footer height is
big enough to hold the picture on each page, leaving a big blank space under
the footer on pages 2 to the end. I want to shrink the footer height on the
second and subsequent pages.

I used the Format event of the PageFooterSection to set the height bigger
(i.e. taller or broader if you prefer) on page one and smaller (i.e. shorter
or narrower) on pages other than one, which seems to work OK. But the report
detail then overprints the taller page footer on page one, falls short of the
shorter footer on page 2, and then finally comes out right on page three and
thereafter.

How can I resolve this?

Thanks in advance for any input

Vaughan

 

[Marshall Barton]

I want to print a small picture in the page footer of my report on page 1
only. I can set the object visible on page one only, but the footer height is
big enough to hold the picture on each page, leaving a big blank space under
the footer on pages 2 to the end. I want to shrink the footer height on the
second and subsequent pages.

I used the Format event of the PageFooterSection to set the height bigger
(i.e. taller or broader if you prefer) on page one and smaller (i.e. shorter
or narrower) on pages other than one, which seems to work OK. But the report
detail then overprints the taller page footer on page one, falls short of the
shorter footer on page 2, and then finally comes out right on page three and
thereafter.

The page has already been formatted by the time the page
footer is processed

Try setting the footer height in the page header's Format
event.

If Me.Page = 1 Then
Me.Section(5).Height = x
Else
Me.Section(5).Height = y
End If

 

[Guest]

Thanks for answering Marshall

I tried what you said, but it didn't work - exactly the same thing happens.
The header/footer format events seem to be triggered for every page before
the report is displayed, then the detail is formatted based on the amended
footer height even for page 1. I can't find a way to intercept it. I have
even tried resetting the height to the taller setting on the last page, but
that doesn't seem to do anything.

I'm at a complete loss. Any more suggestions??

Thanks again

Vaughan

 

[Marshall Barton]

Arrggghhh, I used the wrong section number, It should be:

Me.Section(4).Height

That definitely works in A2003, but I think I remember that
the ability to do this varied in an older version of Access.