ACC: How to Reset the Page Number on Group Level in a Report (104760)

MORE INFORMATION

If Page Number Is Displayed in Page Footer

1. Open the sample database Northwind.mdb (or NWIND.MDB in versions 1.x and 2.0).
2. If you are using version 1.x or 2.0, create the following new macro and save it as Pager:
   

         Macro Name  Action
         --------------------
         Pager       SetValue
   
         Macro Actions
         ----------------
         SetValue
            Item: Page
            Expression: 1
   						

3. Open the Employee Sales By Country report in Design view.
4. In Microsoft Access 7.0 and 97:
   

         Select the Country Header section, and then click the Build button
         for the OnFormat property to examine the event procedure.
   						

   In Microsoft Access 1.x and 2.0:
   

         Select the Country Header section, and then set the section's
         OnFormat property to the Pager macro.
   						

5. Select the Country footer section and set the ForceNewPage property to After Section.
   
   NOTE: If you are using Microsoft Access version 1.x or 2.0 and the group header's Height property is set to 0 inches, the page number is not reset correctly. To correct this problem, either set the group header's Height property to at least 0.007 inches or set the group's KeepTogether property to Whole Section in the Sorting And Grouping dialog box to force two-pass formatting. This is necessary because the OnFormat property is triggered too soon when the section has a height of 0 inches.
   
   NOTE: This behavior no longer occurs in Microsoft Access 7.0 or 97.

If Page Number Is Displayed in Page Header

1. Open the sample database Northwind.mdb (or NWIND.MDB in versions 1.x and 2.0).
2. If you are using version 1.x or 2.0, create the following new macro and save it as Pager:
   

         Macro Name  Action
         --------------------
         Pager       SetValue
   
         Macro Actions
         ----------------
         SetValue
            Item: Page
            Expression: 0
   						

3. Open the Employee Sales By Country report in Design view.
4. In Microsoft Access 7.0 or 97:
   

         Select the Country Footer section, and then click the Build button
         for the OnFormat property, choose Code Builder, and click OK. In the
         code window type the following:
   
            Page = 1
   						

   In Microsoft Access 1.x or 2.0:
   

         Select the Country Footer section, and set the OnFormat property to
         the Pager macro.
   						

5. Set the ForceNewPage property to After Section.
6. Move the control called Page, which displays the page number, to the page header.