How do you stop Access adding accents to words like cafe and deco.

[Max]

In one table, words such as cafe and decor are entered with no accent on the
e, but when using a combo box to look up this field, when you type the word
cafe it automatically changes it to an e with an accent or acute then a
message box will inform you the item is not in the list. Any ideas how to
stop this would be appreciated?

 

[fredg]

In one table, words such as cafe and decor are entered with no accent on the
e, but when using a combo box to look up this field, when you type the word
cafe it automatically changes it to an e with an accent or acute then a
message box will inform you the item is not in the list. Any ideas how to
stop this would be appreciated?

Cafe and Decor are both Auto Correct words ... Tools +
AutoCorrectOptions.
You can either delete the reference to cafe and decor in the
AutoCorrect list (which will effect AutoCorrect for all Office
programs), or set the control's (on the form) Allow AutoCorrect to No
(which only effects that particular control).