Weekly Computer Tip # 196
11 May 2007

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, url http://www.roem.co.uk/tip_53.html or
http://www.roem.co.uk/excel_with_excel.html if you want to find out more about our next Excel seminar.)

Finally, I know there was no tip last week. (Sorry and thanks for noticing!) I was in Scotland for the Bank Holiday Weekend, followed by a few days work in Glasgow where I felt I was on the set of "Taggart", being surrounded by people who spoke like Jackie Reid and Stewart Fraser. There was even a Robbie who sorted out the network connections on Monday. (Thank God, there was no murrrderrr!)

Until next week.

PS I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.

Home   Training   Support   Clients   Contact Details   News   Disclaimer