O'Reilly logo

Microsoft® Office Access™ 2007 Plain & Simple by Curtis D. Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required