Text Control 1st TWO letters uppercase

[ted.martin]

This may seem a daft one but there you go. I have an application where the Business name is a standard text box. Not using any masking or any other special formatting.

One and it only one, business company name has their name spelled with the first two letters in capitals, for example ASmith.

I cannot find any way to get this entry to remain as above; it seems to automatically change to Asmith as soon as the text control loses focus.

Of course, all other entries are, dare I say, normal with only the first letter in uppercase, so whatever the solution is, I don't want the normal entries to change.

Googled it lots and can't find anything that seems to work.

I guess Microsoft have disallowed literal charcaters entires for some reason.

If anyone has any thoughts, I would be greatful.

Thanks all.

 

[pbaldy]

What version? In 2000, it's in Tools/Autocorrect. There's a checkbox to "fix" two capitals.

 

[ted.martin]

2007 and 2010. Will take a look. Thanks.


Posted 5 minutes later = yes thats it. Access Options/Proofing/Autocorrect Options.

Thanks 'PB' well done.

 

[pbaldy]

In 2007 it's in:

Office Button/Access Options/Proofing/Autocorrect Options