Change all upper case letters to lower case

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

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).
 
Check the usage of StrConv(). You could likely put it in a update
query as the new value (ie. Set [FieldName] = StrConv([FieldName],
[ConvertType])
 
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).
Click to expand...

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.
 
Back
Top