Case being changed in table

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
 
R

RonaldoOneNil

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with SET & REF function 0
Name of file opened, being viewed 2
Problem with capitalized letters showing up lower case in a report 2
Cumulative formula for word table 0
sqlite-odbc write conflict 2
Change from all UPPER case letters 5
Differences between lower case and upper case 4
Allow Caps Only in Text Fields 2

Top