Undo changes

ShowUndo changes in Design view

  1. Click the arrow next to Undo Button image.

Microsoft Access displays a list of the 20 most recent actions you can undo.

  1. Click the action you want to undo.

When you undo an action, you also undo all actions above it in the list.


ShowUndo changes when adding or editing records in a datasheet or form

  • Do one of the following:
  • Click Undo Button image on the Table Datasheet, Query Datasheet, or Form View toolbar to take back your most recent change.
  • Click Undo Saved Record on the Edit menu if you have already saved changes to the current record, or have moved to another record.

As soon as you begin editing another record, apply or remove a filter, or switch to another window, you can't use these methods for correcting changes.

ShowUndo changes when adding or editing records in a data access page

  • Click Undo Button image on the record navigation toolbar.

 Note   If you don't see the Undo button or if it appears disabled, it means one of the following:

  • The designer of the page has customized the button. Look for custom instructions on the page on how to undo your changes.
  • The page is read-only and does not support additions or edits.

ShowRevert to a saved version of a form or report

You can discard any changes — including changes to Microsoft Visual Basic code — that you have made in Design view (Design view: A view that shows the design of these database objects: tables, queries, forms, reports, and macros. In Design view, you can create new database objects and modify the design of existing objects.) of a form or report and revert to the last saved version of the form or report.

Once you have reverted to the last saved version of the form or report, you cannot recover the changes that you have made to the form or report since you last opened it.

  • To revert to the last saved version, on the File menu, click Revert.

 Note   This command is not available unless you have opened a form or report in Design view and have made changes to it. The Revert command is not available in Design view of a data access page (data access page: A Web page, published from Access, that has a connection to a database. In a data access page, you can view, add to, edit, and manipulate the data stored in the database. A page can also include data from other sources, such as Excel.).

Applies to:
Access 2003