Report Footer Issue

[Tetol]

I have access 2007.

My report footer contains a legal disclaimer. However, it doesn't print on the last page of the report, at the very buttom.

So the disclaimer usually ends up in diffrent positions on the last page depending on the lenght of the records.

How can I get the report footer to print at the very bottom of the last page?

Thank you in advance.

 

[dhookom]

Could you put the disclaimer in the page footer and then make it invisible on all but the last page?

Duane
Hook'D on Access
MS Access MVP

 

[Tetol]

This would be nice but how do you make it invisible on all but the last page? If possible, this should solve my issue

Thank you.

 

[dhookom]

You would need to add Page numbering controls in the report page footer section. Add the disclaimer to the page footer. Then add code to the On Format event of the page footer like:

   Me.txtDisclaimer.Visible = (Me.Page = Me.Pages)

Duane
Hook'D on Access
MS Access MVP

 

[Tetol]

dhookom - Thank you so much. It worked perfectly.