Report Footer - controlled location

[roaftech]

This being my first post here, I would like to thank all those whose contributions have been helpful to me previously.

I have prepared a report which has a variable number of detail items. This means that the report footer may appear anywhere on the final page of the report, immediately after the final detail item. This is obviously the preferred location when the report footer contains summary info such as totals or averages.



However, in this instance there are no such figures and I am using the report footer for footnotes that appear on the final page only (ie, not part of the page footer). I would prefer the report footer to sit immediately above the page footer, rather than below the detail section. Is there a way to achieve this?

[June7]

See if this helps http://social.msdn.microsoft.com/For...-74afbc5cffa2/

[roaftech]

Thanks for the prompt response.
I read through the link you suggest and the various other links that it led to, and came up with the following hybrid code which gives me the effect that I wanted, but by a different route:

Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
'Used to set the height of text boxes on forms and reports.
'Heights are specified in twips - 1cm = 567 twips
If Me.Page = Me.Pages Then ' check for last page
Me.Label13.Height = 240 ' set the height on last page (twips)
Else
Me.Label13.Height = 0 ' set the height on other pages
End If
End Sub

Label13 is the text box that contains my footnote.
The code might seem more complex than necessary but the 'else' clause allows me to work with the text box at full size on the design page, without having to remember to reset the height to 0 manually.
I suspect that if the footnotes were longer than 1 line then it might be necessary to adjust the page footer height too, to avoid excess blank space on the preceding pages.