Annoying conversion of 2nd character from upper to lower case

  • Thread starter Thread starter Bill R via AccessMonster.com
  • Start date Start date
B

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
 
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.
 
Thanks once again, John, for your "able-bodied" assistance! ;-)

John said:
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!
Click to expand...
[quoted text clipped - 8 lines]
Bill
Click to expand...
Click to expand...

--
Bill Reed

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

Message posted via AccessMonster.com
 
Back
Top