Microsoft KB Archive/203100

= ACC2000: Deleting a Child Section on a Page Does Not Delete Expand Control =

Article ID: 203100

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q203100



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
On a grouped data access page, if you delete the child section of the page, the associated expand control in the parent section is not automatically deleted. Because the expand control is no longer associated with a section of the page, it has no functionality.

Also, if you then re-create the child section of the page, the existing expand control is not re-associated with the new section. Instead, an additional expand control is added to the parent section of the page.



RESOLUTION
Delete the expand control in the parent section from the page. If you decide to re-create a deleted child section, be sure to delete the expand control first.



STATUS
Microsoft has confirmed that this is a problem in Access 2000.



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) Add the following fields to the page.
 * 5) * Customers: CustomerID
 * 6) * Customers: CompanyName
 * 7) * Orders: OrderID
 * 8) * Orders: OrderDate
 * 9) Click Next.
 * 10) Select CustomerID as the field upon which to group your page.
 * 11) Click Finish.
 * 12) On the View menu, click Page View.

Note that there is an expand control that controls whether the Header: CustomersWiz section of the page is expanded.
 * 1) On the View menu, click Design View.
 * 2) Select the Header: CustomersWiz section of the page, and then delete it.

Note that the expand control in the Header: Orders-Customers_CustomerID section of the page is not deleted.
 * 1) Drag the OrderID field from the Orders table from the field list to a new band on the data access page.

Note that a second expand control is placed in the parent section of the page (Header: Orders-Customers_CustomerID).

Additional query words: pra two too many an extra nonfunctional

Keywords: kbbug kbnofix kbdap KB203100

-

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

© Microsoft Corporation. All rights reserved.