Tame your computer - rapid character capture


24-05-2007

In her weekly series for Cambridge Network members, software training expert Karen Roem offers handy tips to help you 'Tame your computer'. This week she describes how to quickly insert or delete characters in a field (Microsoft Access) ...

Today's tip made somebody a very happy bunny during yesterday's Access course I facilitated in London. This person was all in favour of using her keyboard rather than her mouse and was unaware you could quickly add or delete characters to the right of the last character in a selected Access field.

Here's how:

1. Press ENTER or TAB to move from field to field, as normal, which selects the entire field entry.
2. Press F2 to activate Edit mode.

The insertion point appears to the right of the last character. In this mode, you can freely move the insertion point. This allows you to insert and delete single characters.

By the way, this tip works similarly in Excel and is something one of my recent Excel with Excel seminar attendees really liked. (See tip #53, or http://www.roem.co.uk/excel_with_excel.html if you want to find out more about our next Excel seminar.)

24 May 2007

Karen Roem offers software training and support through her company Roem Ltd.
Contact her by email Karen@roem.co.uk or visit her website at http://www.roem.co.uk

 

Karen Roem
Microsoft Office-ionado

Roem Ltd – software training and support