Which of the following starts off with Save undo and redo?

You can undo and redo up to 20 of your last typing or design actions in Access. To undo an action, press Ctrl + Z. To redo an undone action, press Ctrl + Y.

The Undo and Redo features let you remove or repeat single or multiple typing actions, but all actions must be undone or redone in the order you did or undid them – you can’t skip actions. For example, if you change the value of three fields in a record and then decide you want to undo the first change you made, you must undo all three changes.

Similarly, you can undo most design changes that you make to database objects, such as adding a control to a report or adding a sort order to a query field. Design changes must also be undone in order.

In this article

• Undo data entry

• Undo design changes

• Redo actions that you undid

• Help prevent lost work

Undo data entry

• To undo the most recent data entry, press CTRL+Z.

• To undo several actions, do one of the following:

  • On the Quick Access Toolbar, click the arrow next to Undo Typing

    , and then select the actions that you want to undo.

    All of the selected typing actions are reversed. However, the actions that you can undo will begin with the most recent action and you may only undo the actions in the order in which they occurred. For example, you cannot undo just the second typing changes that you made. To undo the second typing change, you must also undo the action that preceded it.

  • If you can’t reach the Quick Access Toolbar (for example, because you are using a modal form), press CTRL+Z repeatedly until the action that you want to undo is undone.

Important: Some actions can't be undone, such as clicking a command on the File tab. When an action cannot be undone, the Undo Typing command changes to Can't Undo.

Top of Page

Undo design changes

You can undo design changes to database objects in the same way that you undo data entry.

• To undo the most recent design change, press CTRL+Z

• To undo several actions, do one of the following:

  • Press CTRL+Z repeatedly until the action that you want to undo is undone.

  • On the Quick Access Toolbar, click the arrow next to Undo

    , and then select the actions that you want to undo.

    All of the selected typing actions are reversed. However, the actions that you can undo will begin with the most recent action and you may only undo the actions in the order in which they occurred. For example, you cannot undo just the second typing changes that you made. To undo the second typing change, you must also undo the action that preceded it.

Important: Some actions can't be undone, such as clicking a command on the File tab. When an action cannot be undone, the Undo command changes to Can't Undo.

Top of Page

Redo actions that you undid

• To redo the most recent action that you undid, press CTRL+Y.

• To redo several actions, do one of the following:

  • Press CTRL+Y repeatedly until the actions are redone.

  • On the Quick Access Toolbar, click the arrow next to Redo

    , and then click the actions that you want to redo.

    The actions are redone in the order in which they are listed. You can only redo the actions in the order in which they occurred. For example, you cannot redo only the second action that you undid. To redo the second action, you must also redo the action that preceded it.

Important: When the Undo and Redo commands are not available, the previous actions cannot be repeated.

Top of Page

Help prevent lost work

Undo can really save the day, but it’s no substitute for regularly saving your work. You can help prevent the loss of work due to errors or crashes by using Backup and Restore, and by using Application Parts (a kind of template).