Unwaanted spelling correction for last name.

[pgoulet]

I have a text field, Lname. When the last name is entered as TATH, the field automatically changes to THAT.

I've cheated by putting a semi-quote "'" as the 5th charector of the last name.

Does anyone have any ideas what is turned on. I have not seen this before in Access.

Thanks Paul

 

[gmmastros]

If I'm not mistaken... You are referring to the Auto Correct 'Feature'.

In Access... Click Tools -> Options and then General tab. You'll the the AutoCorrect options in the upper right corner of the window.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[willir]

ALSO, look at the AutoCorrect "dictionary...
From the menu, "Tools" -> "AutoCorrect"

Ideally, you would want to turn AutoCorrect off when entering a person's name, or address, and then perhaps turn it back on when working within other fields. I have never done this, but it may be do-able (with out using SendKeys). Perhaps the
DoCmd.DoMenuItem

 

[pgoulet]

Willir....

That was it... The Auto Correct dictionary had exactly tath to that in it. I deleted out the offending correction and it worked great.

Thanks for the help.