showing data in on the last page of a report

  • Thread starter Thread starter tope12
  • Start date Start date
T

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?
 
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
 
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?
Click to expand...

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.
 
Back
Top