ACC2: Group Header or Group Data Missing on Page 1 of a Report (130368)

RESOLUTION

This article assumes that you are familiar with Access Basic and with creating Microsoft Access applications using the programming tools provided with Microsoft Access. For more information about Access Basic, please refer to the "Building Applications" manual.

To work around this problem, create a page break before each group value on the report.

To create the page break on your report, follow these steps:

1. Open the report in Design view.
2. Select the group header section and set the ForceNewPage property to None.
3. In the group header section, create a Page Break control at the top of the section and set the following properties for the control:
   

         Name: GroupHdrPageBreak
         Top: 0
   						

4. Create a module and type the following lines in the Declarations section:
   

         Option Explicit
         Dim FirstOne As Integer
   						

5. Type the following functions:
   

         Function RHdrOnFormat()
            FirstOne = -1
         End Function
   
         Function GrpHdrFormat (Rpt As Report)
            If Rpt.page = 1 And FirstOne = -1 Then
               Rpt!GroupHdrPageBreak.visible = False
            Else
               Rpt!GroupHdrPageBreak.visible = True
            End If
            FirstOne = 0
         End Function
   						

6. Set the report header's OnFormat property to the following function:
   

         =RHdrOnFormat()
   						

7. Set the group header's OnFormat property to the following function:
   

         =GrpHdrFormat([Report])
   						

8. Choose Print Preview from the File menu. Note that page 1 contains the first group value and its records.