Change all upper case letters to lower case

N

Need2know

All my data in Access is now upper case. I wish to change it all to lower
case (even better would be to keep first letter of each word upper and make
all other letters lower).
 
S

storrboy

Check the usage of StrConv(). You could likely put it in a update
query as the new value (ie. Set [FieldName] = StrConv([FieldName],
[ConvertType])
 
Top