Why Access changes words as you type them
When you type words into an Access textbox, Access can sometimes change them automatically for you, for example 'CNA', which may be a valid abbreviation in your database, would get automatically changed to 'CAN'. This is even more annoying if you have a textbox with a password input mask, so that you can't actually see what is being typed!
This is caused by the AutoCorrect feature, which corrects spelling mistakes as you type them. There are several ways around this:
- Firstly, you can turn off this feature, by going to Tools|AutoCorrect, and removing the tick from 'Replace Text as you Type'. Note that this will affect any Access database on that computer.
- Secondly, if you want to keep the AutoCorrect feature, you can remove selected words from its list. To do this, select the AutoCorrect screen (Tools|AutoCorrect), and select the word that is being replaced in the list on the left. Then, click on the delete button.
- Finally, there is the option to disable this feature on a control-by-control basis. To do this, open a Form in design mode, and select the Properties of the Control required. Change the Allow AutoCorrect property to No.
Copyright & Disclaimer