showing data in on the last page of a report

[tope12]

i want to put checkboxes in the footer of my report. If possible,how do i
make sure that the checkboxes only show up on the footer of the last page of
a report?

 

[Tom van Stiphout]

On Sat, 17 Jan 2009 07:33:00 -0800, tope12

Put them in the Report Footer rather than the page footer.

-Tom.
Microsoft Access MVP

 

[fredg]

i want to put checkboxes in the footer of my report. If possible,how do i
make sure that the checkboxes only show up on the footer of the last page of
a report?

As Tom suggested, the Report's Report Footer only prints on the last
page.
However, if the check boxes must be in the Page Footer position of the
last page, add a control to the report Page Footer section to
calculate the total number of pages in the report (if you don't
already have one):
=[Pages]
or
="Page " & [Page] & " of " & [Pages]
If you don't wish to actually show the total number of pages, make the
control not visible.

Then code the Page Footer Format event:
Me.Check1.Visible = Me.[Page] = [Pages]
Me.Check2.Visible = Me.[Page] = [Pages]
etc. for each check box.