Text Box issue

[Guest]

Hello,

I have a Form and a Text box on it.

When I type in some text the following happens...

If I type in JEff Smith, Access changes it to Jeff Smith

There is no Input Mask in the Text Box, yet it is still doing it
Also I try this on any new form or even a new database with a new Form &
still it happens.

I am taking a guess it is some Microsoft thing. Any way to stop it, just
allow me to type in what I want even if JEff Anteby seems silly to capitalize
the second character.

Any help would be greatly appreciated.

Thank you,
Jeff

 

[Pat Hartman\(MVP\)]

go to Tools/Autocorrect options and uncheck the option to fix two initial
caps.

 

[Guest]

Hi Pat,

Thank you that worked.

By any chance is their a way to set that through VBA code ?

Thank you,
Jeff

 

[Pat Hartman\(MVP\)]

You can set most options programmatically. I don't know the specific code
to set this option or even if you can, but here's a link to an article in
the MSDN library that should help -
http://msdn.microsoft.com/library/?url=/library/en-us/dnacc2k/html/acglobaloptions.asp?frame=true

If the article doesn't mention specifically the option you want to modify,
play around a little, you may see it with intellisense.