Using AutoCorrect

Have you noticed that when you enter data, Access sometimes changes it? That's AutoCorrect at work, which is really an Office feature. If you use Word or Excel, you've probably noticed that they also occasionally change the data you enter.

AutoCorrect tries to correct your mistakes before you actually enter them. For instance, if you enter teh , AutoCorrect changes it to the . That might or might not be what you want, but most of the time, AutoCorrect does a good job of catching your typos.

Let's take a closer look at the AutoCorrect feature to see just how hard it works for you. To do so, select AutoCorrect Options from the Tools menu to display the dialog box shown in Figure 16.14.

Figure 16.14. Open the AutoCorrect dialog box.


By default, all the options are set:

  • If you enter two uppercase letters at the beginning of a word, AutoCorrect changes the second letter to lowercase.

  • AutoCorrect always capitalizes the first letter in a sentence .

  • AutoCorrect recognizes the names of the week and capitalizes each if you don't.

  • If the first letter of a word is lowercase and the rest are uppercase, AutoCorrect automatically reverses the case and capitalizes only the first letter.

  • AutoCorrect can automatically replace text as you type. This is where the teh/the example we used earlier comes from. Below the Replace Text As You Type option is a list of strings AutoCorrect watches for (in the Replace column). When AutoCorrect encounters one of the strings in the Replace column, it changes it to the corresponding string in the With column.

If you don't want AutoCorrect to change something, just uncheck the appropriate option.

Altering AutoCorrect to Fit Your Circumstances

The AutoCorrect feature can be annoying if it makes a change you don't like and you end up correcting AutoCorrect. Fortunately, you can make AutoCorrect behave the way you want it to. Let's take a look at a couple of examples.

The first option in the Replace Text As You Type option is (c) and . Every time you type (c), AutoCorrect changes it to . If you enter (c) frequently, this can quickly become annoying. The simple solution to this problem is to delete that entry. To do so, display the AutoCorrect Options dialog box, select the (c)/ entry under the Replace Text As You Type option, and click the Delete button at the bottom-right corner of the dialog box.

You can also add Replace As You Type Text entries of your own. Perhaps your best friend's last name is Gray and you often type it as Grey. AutoCorrect will fix the error for you. Display the AutoCorrect Options dialog box and enter Grey in the Replace box, enter Gray in the With box, and then click Add . The next time you type Grey , AutoCorrect will change it to Gray . The interesting thing about this particular entry is that AutoCorrect is case sensitive. So, if you enter grey instead of Grey , AutoCorrect won't change the spelling to gray . It only works if you capitalize the g , as in Grey .



A quick way to undo an AutoCorrect correction without permanently changing the options is to press Ctrl+Z after AutoCorrect makes a change. Doing so returns the text you entered.

Adding to AutoCorrect While Correcting Your Spelling

Spell Check is another shared Office feature you probably use often. (I know I do!) If you encounter a word that Spell Check doesn't recognize, you can add it to your dictionary. That way, Spell Check won't complain about the word not being in the dictionary the next time you use it. Instead, AutoCorrect will simply correct the typo when you enter it. This capability is especially helpful when entering words that aren't common, such as Latin names for flowers.



AutoCorrect is a shared Office feature, meaning any changes you make to the settings in Access also affect Excel and Word.

To add a word to the dictionary, open the Plants form and select Spelling from the Tools menu (or press F7 ), with Calendula as the current record. Right away, the feature finds an entry that's not in the dictionaryAchillea, as shown in Figure 16.15.

Figure 16.15. Part of the plant's Latin name isn't found in the AutoCorrect dictionary.


If you don't want Spell Check to stop on this word again, click the AutoCorrect button at the bottom-right of the dialog box. When you're done, click Close .

Now, return to the first record by clicking the First button on the form's navigation bar. Then press F7 to rerun the SpellCheck. This time, it ignores Yarrow's Latin name.



You can turn off the AutoCorrect feature for individual form controls. Open the form in design view and doubleclick the control in question. Then, set the control's AllowAutoCorrect property to No . (To learn more about setting properties in a form, see Chapter 13, "Customizing Forms.")

Absolute Beginner's Guide to MicrosoftR Access 2002
Absolute Beginner's Guide to MicrosoftR Access 2002
Year: 2002
Pages: 133 © 2008-2017.
If you may any questions please contact us: