Case being changed in table

  • Thread starter Thread starter iamnu
  • Start date Start date
I

iamnu

I have a Text field in a table. It has no Format or Input Mask
specified. When I enter Two Capital letters in a row (and more than
three characters), something is changing the second letter to lower
case.
If I enter Three Capital letters in a row, then the second letter is
NOT changed to lower case.

How do I prevent this from happening?

Example:
I enter ABCtest, and I get ABCtest
I enter ABtest, and I get Abtest.....THIS IS WRONG
I enter AB Test, and I get AB Test
 
It's the AutoCorrect options. Not sure what version of Access you are
running, but in 2003, Select Tools - AutoCorrect options and untick the
"Correct Two Initial Capitals"
 
Back
Top