ACC2000: Data Page Size Ignored When You Add Group Filter Control to a Page Section (225955)



The information in this article applies to:

  • Microsoft Access 2000

This article was previously published under Q225955
Moderate: Requires basic macro, coding, and interoperability skills.

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

SYMPTOMS

After you add a group filter control to a data access page, the page displays only one record at a time. This happens even though you have set the DataPageSize property to a value greater than 1.

RESOLUTION

You can use two frames on the page instead of a group filter control. For example, on the page for one of the frames, you can add a dropdown list control and add a server filter that pulls a value from the list. On the page for the other frame, you can set the DataPageSize property.

For additional information about creating a page with frames, please see the following article in the Microsoft Knowledge Base:

232566 ACC2000: How to Simulate a Subform or Subreport on a Data Access Page

STATUS

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

MORE INFORMATION

If you set the data page size to some specific value, that value determines how many records are displayed when you view the page. If, however, you place a group filter control within the Caption section of the page, the value assigned to the DataPageSize property is ignored, and only one record is displayed at any particular time.

Steps to Reproduce Behavior

  1. Open the sample database Northwind.mdb.
  2. Click Pages in the Database window, and then double-click Create data access page in Design view.
  3. In the new data access page, set the Height property of the Section:Unbound section to 0.5in.
  4. In the Field List box, expand Tables, expand Orders, and then drag the OrderID field to the Section: Unbound section.
  5. On the View menu, click Sorting and Grouping.
  6. In the Sorting and Grouping dialog box, set the Caption property to Yes and set the DataPageSize property to 5.
  7. On the View menu, click Page View. Note that records 1 through 5 of approximately 830 records in the Orders table are displayed.
  8. On the View menu, click Design View.
  9. With both the toolbox and the Field List box open, click Dropdown List in the toolbox, and then in the Field List box, expand the Employees table.
  10. Under the Employees table, right-click the LastName field and hold down the right mouse button. While holding down the right mouse button, drag the LastName field to Caption: Orders section, and then release the right mouse button. Note that a shortcut menu appears.
  11. On the shortcut menu, click Group Filter Control.
  12. On the View menu, click Page View, and then click any last name in the LastName list.

    Note that the page now displays only one record at a time instead of five records at a time, even though the DataPageSize property is still set to 5. Note also that you cannot change the value in the DataPageSize property.

Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbbug kbDAP kbpending KB225955