PRB: AutoCorrect Does Not Replace Text You Specified

Article ID: Q133088
Creation Date: 24-JUL-1995
Revision Date: 03-DEC-1996

The information in this article applies to:

Microsoft Access versions 7.0, 97

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

When you enter text into a field that you expect the AutoCorrect feature to replace, the text is not replaced with the text you specified in the AutoCorrect dialog box.

CAUSE

AutoCorrect does not replace the text you enter with the changes you specified if the number of characters in the replacement text exceeds the field size set for the specific field.

RESOLUTION

Make sure the replacement text you specify for a field does not exceed the field size of that field.

MORE INFORMATION

Steps to Reproduce Behavior

Open the sample database Northwind.mdb.
On the Tools menu, click AutoCorrect.
In the Replace text box, type "AC95" (without the quotation marks).
In the With text box, type "Access for Windows 95" (without the quotation marks).
Click OK to close the AutoCorrect dialog box.
Open the Categories table in Datasheet view.
In the CategoryName field, type "AC95" (without the quotation marks.)
Move the pointer to the Description field.
In the Description field enter, "AC95" (without the quotation marks). Note that AutoCorrect does not replace "AC95" with "Access for Windows 95" in the CategoryName field because the FieldSize property of that field is set to 15 characters, which the replacement text exceeds. "Access for Windows 95" does appear as the replacement text in the Description field because the FieldSize property of that field is large enough to accept the replacement text.

REFERENCES

For more information about AutoCorrect, search the Help Index for "AutoCorrect," or ask the Microsoft Access 97 Office Assistant.

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.