ACC2002: Cannot Undo Typing After a Subform Is Switched from Form View to Datasheet View (287458)

MORE INFORMATION

This behavior occurs only when you change the view of a subform from Form to Datasheet while the form is open. It does not occur if you change the subform's Default View property to Datasheet in Design view.

Additionally, this behavior occurs only when you use the key combination CTRL+Z to undo typing, or when you click Undo on the toolbar. You are still able to undo typing by pressing ESCAPE or by pressing CTRL+Z a second time.

Steps to Reproduce the Problem

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, under Objects, click Forms, and then double-click Create form by using wizard.
3. In the Tables/Queries box, select Table: Customers. In the Available Fields box, select CustomerID, CompanyName, and ContactName, and then click the Add button [>].
4. In the Tables/Queries box, select Table: Orders. In the Available Fields box, select OrderID and OrderDate, and then click the Add button [>]. Click Next.
5. Click Next again to organize the data by Customers in a form and subform.
6. Select Tabular layout for the subform and click Next.
7. Click Next again to accept the Standard style.
8. Type TestCustMain in the Form box and TestCustOrdSub in the Subform box. Click Finish to create the form.
9. Click the OrderDate box in the subform's first record and type 1/1/1997. Press CTRL+Z and note that the last digit that you typed is undone.
10. Right-click the subform, point to Subform on the context menu, and then click Datasheet.
11. Repeat step 9 and note that the last character typed is not undone as expected.