Microsoft KB Archive/203106

= 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


 * Microsoft Access 2000 Standard Edition

-



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.



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.

