Prevent all caps

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Simply use the LCase() function, as in "a = LCase(a)"

hope this helps

Sam
 
Back
Top