Open the Tools menu and choose Spelling to open the Spelling dialog box.
When Access finds a word that does not appear in its dictionary, the word appears in the Not In Dictionary field, with suggested corrections in the Suggestions area.
If the word is, in fact, misspelled and the correct spelling is listed, click the correct spelling to select it, and click the Change button to change just this instance of the word.
To change all instances of the misspelled word, click the correct spelling in the Suggestions list and then click the Change All button.
Because a database table is likely to include names and other proper nouns that are probably not in the speller's dictionary, you may find that checking spelling isn't as useful in this program as it is in, say, Word. Still, you can and should check the spelling of your entries to catch any mistakes.
If Access incorrectly flags a word as a misspelling, you can opt to ignore the flag. Click Ignore to skip just this instance, or Ignore All to skip all instances.
If Access incorrectly flags a word as a misspelling, and it's one you use often, click the Add button to add the word to the dictionary that Access uses to check your spelling.
Access flags the next word not found in its dictionary. Continue making selections for each of the flagged words. Access notifies you when the spell check is complete; click OK.
Skipping a Field
To speed the spell-check process, you can have Access ignore the entries in a particular field. To do so, click the Ignore Field button. (The exact name of the button varies depending on what field is flagged. For example, if you wanted to ignore entries in the LastName field, you'd click the Ignore LastName Field button.)
If you often misspell a particular word, you can configure Access to always correct it automatically by selecting the correct spelling in the Suggestions list and then clicking the AutoCorrect button.