Microsoft KB Archive/287458

= ACC2002: Cannot Undo Typing After a Subform Is Switched from Form View to Datasheet View =

Article ID: 287458

Article Last Modified on 11/6/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q287458



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
In Microsoft Access, you may be unable to undo typing in a subform as expected by pressing CTRL+Z after you change the view of your subform.



CAUSE
This behavior can occur if you have switched the view of the subform from Form to Datasheet.



RESOLUTION
To work around this issue, press ESCAPE or press CTRL+Z a second time.



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



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.

Additional query words: pra

Keywords: kbbug KB287458

-

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

© Microsoft Corporation. All rights reserved.