entries into table "correcting" itself

[Papa Jonah]

I have a table that is used to relate managers to their organization.
An organization has changed names and I am trying to update the table. The
new name is "NWO". When I change the field, it is "correcting" itself to
read "NOW". I haven't seen this before, and I can't find any setting that
stops this from happening.
Any ideas?

TIA

 

[Ken Snell [MVP]]

It's in the AutoCorrect setting. See Tools | AutoCorrect Options ...

There likely is an entry there to auto correct the NWO spelling to NOW.
Either turn off autocorrect or delete that entry from the list.

 

[John Vinson]

I have a table that is used to relate managers to their organization.
An organization has changed names and I am trying to update the table. The
new name is "NWO". When I change the field, it is "correcting" itself to
read "NOW". I haven't seen this before, and I can't find any setting that
stops this from happening.
Any ideas?

TIA

It's a bit obscure, but you can in fact turn off this inappropriate
behavior a couple of different ways.

Tools... Options... Spelling. Check Autocorrect Options and uncheck
the "correct as you type" checkbox.

Or, to leave this feature on in general but to turn it off for this
field, use a Form to enter data (table datasheets should generally NOT
be used for anything but debugging!) and set the "Allow AutoCorrect"
property of the textbox for this field to No.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps