Entering Data Using AutoCorrect

When you enter data into a table, Access examines what you type and corrects any common spelling errors it knows about. You can also add your own AutoCorrect values to streamline data entry—for example, you could have Access recognize the abbreviation sarsp and replace it with sarsaparilla. If you find that Access insists on changing a text entry that you know is correct, you can delete a particular AutoCorrect entry. As an example, one of your projects might have the code name AMDE, which Access automatically changes to MADE.

Add Text with AutoCorrect

  1. Open a table in Datasheet view.

  2. Begin typing text in a cell.

  3. When ...

Get Microsoft® Office Access™ 2007 Plain & Simple now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.