Prevent all caps

[Guest]

I need to either prevent users from entering information in ALL CAPS or have
Access 2003 convert the ALL CAPS to lower case/regular typing. Any ideas on
how to do this?

 

[Rick B]

That would be hard to do. I'm guessing you are entering names? Some names
have more than one capitol letter.

St. James
McDonald
Mac Donald
de los Santos

 

[OfficeDev18 via AccessMonster.com]

Simply use the LCase() function, as in "a = LCase(a)"

hope this helps

Sam