Discussion Locked

MS Access cannot enter "Withe" as text

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

In MS Access 2000 & 97 a user cannot enter the word "Withe" in a box that has been defined as text.

"Withe" gets truncated automatically to "With".

It's as though Access thinks "Withe" should be the keyword "With".

For information, "Withe" happens to be a surname

5 replies

by eschlangen

MS Access uses the same "autocorrect" feature that is available in MS Word. On a form, the textbox has a property (found under the Other tab) called AllowAutoCorrect. This is set to True by default but can be set to False to turn off the AutoCorrect feature. Unfortunately, the datasheet view of a table also has this feature and I have not been able to find a way to turn it off there. Hope this helps!

by lmayeda

Go to WORD, Tools, autocorrect then scroll down till you see "withe", highlight and delete. The next time you enter ACCESS, you should be able to enter the text without it auto-correcting. I had the same problem with Word correcting the abbreviation of our company name from "HSI" to "HIS" so we had some incentive to solve the problem.

This discussion is closed to new replies.