Turn on or off automatic correction of text and data

Microsoft Office Access 2003

  • On the Tools menu, click AutoCorrect Options.
  • Do one or more of the following:
    • To set capitalization options, select or clear the second through the fifth check boxes in the dialog box.
    • To correct your text by replacing with another string, select the Replace text as you type check box.

      Note  AutoCorrect won't correct text that was typed before you selected the Replace text as you type check box.

      To add an entry that you want corrected automatically, do the following:

      1. Select the Replace text as you type check box.
      2. In the Replace box, type the text that you want corrected automatically.
      3. In the With box, type the corrected text.
      4. Click Add.

    • To specify exceptions to capitalization options, click Exceptions, and specify strings that you do not want corrected.
  • ShowOverride AutoCorrect settings in Form view or Datasheet view

    When AutoCorrect replaces a string based on the rules specified in the AutoCorrect Options dialog box, it displays the AutoCorrect Options smart tag to the right of the corrected text. Click the smart tag, and do one of the following:

    • To keep what you typed, click Change... or Undo... .

      Note  To go back to the corrected text, click the smart tag again, and click Redo AutoCorrect.

    • To reverse the correction and update the list of rules or exceptions in the AutoCorrect Options dialog box, click Stop... .
    • To display the AutoCorrect Options dialog box, click Control AutoCorrect Options.

    Note  You can control the display of the AutoCorrect smart tag by selecting or clearing the Show AutoCorrect Options button checkbox in the AutoCorrect Options dialog box.

    ShowAdd an AutoCorrect entry while checking spelling

    1. In the Spelling dialog box, select the correct item in the Suggestions box, or correct the text in the Not In Dictionary box.
    2. Click AutoCorrect in the Spelling dialog box. When you receive a message asking if you want to use this word and continue checking, click Yes.

      The next time you type the text as it appeared before you corrected it in the Not in Dictionary box, Microsoft Access automatically changes it to the corrected text.

    Note  By default, AutoCorrect is enabled for all text boxes and combo boxes in Form view. To disable this feature for a specific control, set the control's AllowAutoCorrect property to No.