Cut, Copy, Paste, and Undo


These operations are similar to the ones in Word 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:

  • 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.

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

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 the same.

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.


Hints & tips

The textbox class in Visual FoxPro 9 has a new Autocomplete property which shows the user the previous values that have been entered in that textbox.
Autocomplete in VFP 9

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

FoxPro has always had functions to read and write files at a low level...
Foxpro low level file functions

More...
More pages of hints and tips for users of Microsoft FoxPro and Access databases.

Site Map