Article ID: 128223
Article Last Modified on 11/6/2000
APPLIES TO
- Microsoft Access 2.0 Standard Edition
This article was previously published under Q128223
SYMPTOMS
Advanced: Requires expert coding, interoperability, and multiuser skills.
The OnFormat event procedure is triggered on the page before a group header or a group footer section is printed. This problem happens when the ForceNewPage property is set to Before Section to force the section to print on the next page. For example, the event is triggered on page 1, but the section prints on page 2.
CAUSE
If a group header or group footer section's Height property is set to 0 inches, the OnFormat event property is triggered before the section is moved to the next page rather than after.
RESOLUTION
To work around this problem, set the group header or group footer section's Height property to at least .007 inches.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Access version 2.0. This problem no longer occurs in Microsoft Access version 7.0.
MORE INFORMATION
The behavior described above can also reset the page number for a group header or group footer incorrectly.
Steps to Reproduce Behavior
CAUTION: Following the steps in the example will modify the sample database NWIND.MDB. You may want to back up the NWIND.MDB file, or perform these steps on a copy of the NWIND database.
Open the sample database NWIND.MDB, and create a new macro as follows:
Macro Name Action -------------------------- GroupHeaderFrmt MsgBox GroupHeaderFrmt Actions ------------------------------------------- MsgBox Message: =[Category Name] & " " & [Page]
- Open the List Of Products By Category report in Design view.
- Move the Category Name text box in the Category Name group header section to the detail section.
Set the properties for the Category Name group header section as follows:
ForceNewPage: Before Section OnFormat: GroupHeaderFrmt Height: 0
- Preview the report. Note that the message box displays "Beverages1."
Steps to Work Around Problem
- In step 4 above, increase the Category Name group header section's Height property to .007.
- Preview the report. Note that no message is displayed until you preview page 2.
REFERENCES
Microsoft Access "User's Guide," version 2.0, Chapter 22, "Sorting and Grouping Data," pages 547-580
For more information about sorting and grouping, search for "Sorting and Grouping," and then "Sorting and Grouping Command (View Menu)" using the Microsoft Access Help menu.
For more information about resetting the page number with group headers and footers, please see the following article in the Microsoft Knowledge Base:
104760 ACC: How to Reset the Page Number on Group Level in a Report
Keywords: kbbug kbusage KB128223