How do I determine how many pages in a section?

[kwixster]

​
I've been developing Access apps for over 16 years and thought I could solve any problem. This one, however, took up way too much time today so I decided to ask for help from people smarter than me.
I'm working on an app for an organization to print out activity sign-up sheets. Each sheet has info at the top and spaces below to sign-up. There's about 80 activities and most sheets are one page. Some sign-up sheets, however, are two or three pages. The organizer would like to put at the bottom of the multi-page sheets a note that says "continued on next page" so people don't think all the spaces are filled.
Here's my problem: I want the administrator to be able to print all the sign-up sheets in one go, including the multi-page sheets. I can't find a way to know how many pages are in each section so I can, programmatically put the continued notice at the bottom where appropriate. I'm guessing it would be in the On Format event. But how do you know how many pages a section is going to take?
I'm new to this forum. Thanks for any help!

 

[JHB]

Depending of how you've set up your report, maybe the below link could give you some ideas.
http://access.mvps.org/access/reports/rpt0013.htm
Else post a stripped down version of your database with some sample data, zip it because you haven't post 10 post yet.

 

[kwixster]

Thanks. Your link ultimately lead to me finding the solution. One interesting issue I found: In Access 2010, the Me.Pages property is not updated unless it is a control in the design. In code only, it stays =0. My solution was to put it on the page but make it not visible. I'm guessing MS decided it took to much overhead to compute if it wasn't going to be used in the report.

 

[JHB]

Good you got it solved!