Change all upper case letters to lower case

[Guest]

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).

 

[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])

 

[fredg]

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).

TO CHANGE THIS to
to change this:
[FieldName] = LCase([FieldName])

TO CHANGE THIS to
To Change This:
[FieldName] = Str(Conv([FieldName],3)

Note that the above will incorrectly capitalize names which should
contain more than one capital letter, i.e. McDonald, O'Brien, IBM, as
well as other names which should not be capitalized at all, i.e. van
der Meer, etc.