Show/Hide page numbers in a report's Group section
Posted on 2001-09-04
Background: I have an Access 97 report that generates invoices for mailing. A single report consists of several invoices that print as a single report. Most invoices are only 1 page long, but the level of detail or formatting rules can result in more than one page for that individual invoice within the report. There is no way of knowing ahead of time how many pages a given invoice will be.
I have page numbers showing on the bottom of each page. By resetting .page = 1 in the GroupHeader_Format sub of the report I can correctly show the page numbers for all invoices in the report. However, my client only wants page numbers to show when the individual invoice is more than one page. The Pages property only keeps track of the total pages of the entire report.
Question: Is there a way of knowing how many pages are in a single Group section of the report (a particular invoice) to use that number to test whether to hide or show the control displaying the page number for that Group section? Seems to be a limitation in Access to have a forward look at that level of detail (anything less than the entire report).