Cut, Copy, Paste, and Undo

Cut, Copy, Paste, and Undo are standard operations in Windows and Microsoft Office. They work inside an Access database in the same way that they work in Word or Excel but you can do much more with them in Access.

Using Cut, Copy, Paste, and Undo

Like Word and most other Windows applications, the user interface gives you four ways of calling these operations. You can use:

  • Buttons on the toolbar.
  • Options on the Edit menu.
  • Options on the short-cut menu that appears when you right-click.
  • CTRL+X, CTRL+C, CTRL+V, and CTRL+Z keyboard shortcuts.

Where to use them

The short answer is - 'Almost anywhere'.

In a table

You can cut, copy, and paste:

  • part of a field.
  • a whole field.
  • several fields.
  • an entire record.

Note that you can undo changes to a single record but you cannot undo a deleted record.

Use Paste Append from the Edit menu to paste a new record into a table.

On a form or report

Use copy and paste to create a duplicate of an existing control - especially if you've put some effort into formatting the original and you need another one that looks exactly the same.

Note that the new control will have the same properties as the original but none of the VBA code in the methods will be copied.

Use Undo:

  • if you've made a mistake changing the size or position of a control.
  • to restore a control you've deleted.
  • to undo a change to the appearance of a control.

In the Database Window

Use copy and paste to make a backup copy of a form or report before modifying it.

MS Access technical tips

Visual FoxPro technical tips

General Tips

 

More tips from Alvechurch Data

Alvechurch Data - Microsoft FoxPro and Access Database Development and Training

Alvechurch Data are based close to Birmingham and provide Microsoft Access and Visual FoxPro training, development and support.

Read More

Custom Toolbars

Your Access database will look more impressive if you add custom toolbars.

Read More

Development Services

Alvechurch Data are based in Birmingham and specialise in the development of Microsoft Access and Visual FoxPro databases. We have fifteen years experience developing databases for small business use.

Read More

Access and Visual FoxPro Training

Microsoft Access and Visual FoxPro training courses and workshops offered by Alvechurch Data in Birmingham.

Read More

Support Services

How Alvechurch Data can help you with maintenance and support of your Access and FoxPro databases.

Read More