Knowledge Base

ACC2000: Error When You Drag the Last Field Out of a Grouping Section of a Data Access Page

Article ID: 203106

Article Last Modified on 6/28/2004

APPLIES TO

This article was previously published under Q203106
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 try to drag the last field out of a grouping section on a data access page, you receive the following error message:
This field can not be deleted because it is last field in a grouping section. Delete the grouping section instead.
When you click OK, the field moves back into the grouping section.

CAUSE

Grouping sections on a data access page must have at least one field; therefore, you cannot delete all the fields from the section.

RESOLUTION

To remove the last field from a grouping section, follow these steps:
  1. Select the control that you want to move.
  2. On the Edit menu, click Cut.
  3. Click the section into which you want to move the control.
  4. On the Edit menu, click Paste.
To get the page to look like it did before you created the groups, you should delete the grouping section for the promoted section, and then change the DataPageSize property for the remaining section. To do so, follow these steps:
  1. Select the grouping section for the promoted field.
  2. On the Edit menu, click Delete.
  3. On the View menu, click Sorting and Grouping.
  4. In the Sorting and Grouping dialog box, change the DataPageSize property to 1.

STATUS

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

MORE INFORMATION

Steps to Reproduce the Behavior

CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

  1. Open the sample database Northwind.mdb.
  2. In the Database window, click Pages under Objects.
  3. Click New .
  4. In the New Data Access Page dialog box, click Page Wizard, click the Categories table in the Choose the table or query where the object's data comes from list, and then click OK.
  5. Move CategoryName from the Available Fields list to the Selected Fields list, and then click Finish.
  6. Right-click the CategoryName field, and then click Promote.
  7. Drag the CategoryName field back down to the Categories header section.
  8. Note that you receive the error message that is mentioned in the "Symptoms" section of this article.

REFERENCES

For more information about grouping in data access pages, click Microsoft Access Help on the Help menu, type group records on a data access page in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

Additional query words: pra

Keywords: kberrmsg kbbug kbdap kbpending KB203106


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.