Annoying conversion of 2nd character from upper to lower case

[Bill R via AccessMonster.com]

I'm trying to enter the text "MMbtu" in a field, but Access converts it to
"Mmbtu". Thanks for the suggestion, Access, but NO THANKS!

Is there anyway to get this string into a table text field? Other entries may
require the 1st 3 characters or only the 1st character to be caps, so I can't
use an input mask or formatting.

Thanks,

Bill

--
Bill Reed

"If you can't laugh at yoursel, laugh at somebody else"

Message posted via AccessMonster.com

 

[John Spencer]

Go to Tools: Autocorrect and uncheck Correct Two Initial Capitals, or
uncheck Replace Text as you Type

Or set the Allow Autocorrect property of the control to false. I do this
globally on my forms by running a vba routine to set the property for all
the form controls to false.

You can also try typing Control-Z immediately after it happens.

 

[Bill R via AccessMonster.com]

Thanks once again, John, for your "able-bodied" assistance! ;-)

Go to Tools: Autocorrect and uncheck Correct Two Initial Capitals, or
uncheck Replace Text as you Type

Or set the Allow Autocorrect property of the control to false. I do this
globally on my forms by running a vba routine to set the property for all
the form controls to false.

You can also try typing Control-Z immediately after it happens.

I'm trying to enter the text "MMbtu" in a field, but Access converts it to
"Mmbtu". Thanks for the suggestion, Access, but NO THANKS!

[quoted text clipped - 8 lines]

Bill

--
Bill Reed

"If you can't laugh at yoursel, laugh at somebody else"

Message posted via AccessMonster.com