ACC2000: Deleting a Child Section on a Page Does Not Delete Expand Control (203100)


The information in this article applies to:

  • Microsoft Access 2000
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.

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. Add the following fields to the page.
    • Customers: CustomerID
    • Customers: CompanyName
    • Orders: OrderID
    • Orders: OrderDate
  5. Click Next.
  6. Select CustomerID as the field upon which to group your page.
  7. Click Finish.
  8. 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.
  9. On the View menu, click Design View.
  10. 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.
  11. 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).
Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbbug kbDAP kbnofix KB203100
©2004 Microsoft Corporation. All rights reserved.