Working with multiple undo and redo in Access - Access

Click here to switch to other Office Online sites worldwide

United Kingdom (change) | All Microsoft Sites

	Microsoft Office Access

Search

	Word 2007 Outlook 2007
Get up to speed

	Get your business online Get help using Office 2007
Your business

	Check for free updates
Office updates

Microsoft Office Access

» Access Home

Product Information

» Overview

» Top 10 Benefits

» See it in Action

» Compare Features

» Try Now

» Buy Now

Help and How-to

» Access 2007 Help

» Access 2003 Help

» Access 2002 Help

» Access 2000 Help

Choose your version

Training

» Access 2007 Training

» Access 2003 Training

» Access 2007 Demos

» Access 2003 Demos

Templates

» Templates for Access

Support and Feedback

» Product Support

» Send Us Your Comments

Technical Resources

» Developer Center

» Office Resource Kit

Additional Resources

» Office Marketplace

» Discussion Groups

» Access Solutions

» Access MVPs

Home > Products > Access > Access 2003 Help and How-to > Working with Data

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Printer-Friendly Version

Working with multiple undo and redo in Access

Applies to: Microsoft Office Access 2003

Applies to
Microsoft Office Access 2003 Microsoft Access 2002

In Access, the Undo and Redo options allow you to undo or redo one or several changes at once. However, the range of operations that you can undo or redo will always begin with the most recent operation and you may only undo or redo operations in the order in which they took place. For example, you cannot undo just the second, fourth, and eighth changes you have made to your table design.

Show Views where multiple undo and redo are available

Access provides multiple undo and redo in the following views:

Views	MDBs	ADPs
Table Design	yes	no
Query Design	yes	n/a
Database Diagram Design	n/a	no
View Design	n/a	yes
Stored Procedure Design	n/a	yes
Function Design	n/a	yes
Trigger Design	n/a	no
Form Design	yes	yes
Report Design	yes	yes
Page Design*	yes	yes
Macro Design	yes	yes
Database Container (DBC)**	yes	yes

n/a = Not Applicable
*For more information on multiple undo and redo in data access pages, see Access Help.
**The DBC has undo functionality only

Show Undo or redo an action

Access maintains a list of the last 20 actions and lets you undo each, in sequence. Similarly, you can redo any of the last 20 actions that you've undone by using the Redo command, where available.

Do one or more of the following:

Undo the last action you performed Click Undo. If you click Undo again, Access will undo the action you performed before that, and so on down the list.
Undo another action or sequence of actions Click the arrow next to Undo to see a list of the most recent actions that you can undo, and then select the action or actions that you want to undo.

Example of multiple undo in Access

Redo the last action you undid Click Redo.
Redo another action or sequence of actions Click the arrow next to Redo to see a list of the most recent undone actions that you can redo, and then select the undone action or actions that you want to redo.

Example of multiple redo in Access

Notes

The keyboard shortcut for Undo is Ctrl+Z.
The keyboard shortcut for Redo is Ctrl+Y.
The default settings have the Undo button only available in Browse mode and the multiple Undo button and multiple Redo button only available in Design mode.

Get Office 2007