Microsoft KB Archive/202129

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

Article ID: 202129

Article Last Modified on 7/15/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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.



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

Customers: CustomerID

Customers: CompanyName

Orders: OrderId

Orders: OrderDate

 Click Next. 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.</li> 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.</li> Select the Group Record Source that is named Orders-CustomerID, and then change the NavigationSection property value to No.</li> Manually select the section of the page that is named NavigationSection: CustomersWiz, and then delete it.</li> On the View menu, click Page View.</li> On the View menu, click Design View.</li> Note that the DataPageSize property value for the Group Record Source, Orders-CustomerID, is set to 1, and for CustomersWiz, is set to All.</li></ol>

Additional query words: prb

Keywords: kbdap kbprb KB202129

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.