ACC2000: Records Are Not Displayed When Group Header Is Not on Data Access Page (200387)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q200387
Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SYMPTOMS

When a grouped data access page does not specify a group header for the outermost group, the page will not display any records for either the parent or child groups. This is the case even when the ExpandedByDefault property for that group record source is set to Yes.

RESOLUTION

The group record source must have a header section to display records.

However, that section does not have to include any controls nor does the height of that section have to exceed 0". In order to format the page so that it appears not to have a header section, you can change both of these settings.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Open the sample database Northwind.mdb.
  2. In the Database window, click Pages under Objects, and then click New.
  3. In the New Data Access Page dialog box, click Page Wizard, and then click OK.
  4. On the first page of the Page Wizard, add the following fields to the page:
    • Categories: CategoryID
    • Categories: CategoryName
    • Products: ProductID
    • Products: ProductName
  5. Click Next.
  6. On the second page of the Page Wizard, choose to group the page by CategoryID.
  7. Click Finish.
  8. If the Sorting and Grouping dialog box is not displayed, click Sorting and Grouping on the View menu.
  9. Select the group record source Products-CategoryID.
  10. Change the ExpandedByDefault group property to Yes.
  11. Change the GroupHeader group property to No. Note that you receive the following message:

    You are about to delete this section. If you click Yes, the controls you placed in this section will be deleted and you won't be able to undo this operation. Are you sure you want to delete these controls?

  12. Click Yes.
  13. On the View menu, click Page View.
Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbbug kbDAP kbpending KB200387
©2004 Microsoft Corporation. All rights reserved.