ACC2000: DataPageSize Property Changed to All When You Manually Delete Navigation Section on a Data Access Page (202129)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q202129
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 you delete the navigation section of a data access page by selecting the section and then manually deleting it, the DataPageSize property of the associated section is automatically changed from its original setting to All. On a grouped data access page that has multiple navigation sections, only the section that was associated with the deleted navigation section is changed. All other navigation sections on that page retain their original DataPageSize property values.

RESOLUTION

To resolve this problem, consider the following:
  • Although the value for the DataPageSize property is changed, you can still edit it. Therefore, you can reset this property to the value that you want.
  • You can remove the navigation section associated with any group on a page through the Sorting and Grouping dialog box. When you remove it in this manner, the DataPageSize property setting is retained.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Open the sample database Northwind.mdb.
  2. In the Database window, click Pages, and then click New.
  3. In the New Data Access Page dialog box, click Page Wizard, and then click OK.
  4. Add the following fields to the page:

    Customers: CustomerID
    Customers: CompanyName
    Orders: OrderId
    Orders: OrderDate

  5. Click Next.
  6. On the second page of the Page Wizard, select Customers: CustomerID as the field on which to group the data access page, and then click Finish.
  7. If the Sorting and Grouping dialog box is not already visible, click Sorting and Grouping on the View menu.

    Note that by default, the DataPageSize property for each of the Group Record Sources is set to 1.
  8. Select the Group Record Source that is named Orders-CustomerID, and then change the NavigationSection property value to No.
  9. Manually select the section of the page that is named NavigationSection: CustomersWiz, and then delete it.
  10. On the View menu, click Page View.
  11. On the View menu, click Design View.
  12. Note that the DataPageSize property value for the Group Record Source, Orders-CustomerID, is set to 1, and for CustomersWiz, is set to All.
Modification Type:MinorLast Reviewed:7/15/2004
Keywords:kbDAP kbprb KB202129
©2004 Microsoft Corporation. All rights reserved.