Converting CASE

  • Thread starter Thread starter android
  • Start date Start date
A

android

I have kept my book collection on Access and it is huge. For some reason
I entered everything in upper case. Is there any way of converting the
case to sentence case (i.e. just Caps where needed and the rest lower
case.:confused:
 
StrConv(strTextToConvert, vbProperCase) will convert the first letter of
every word in string to uppercase. If you only want the first letter to be
capitalized, try

UCase(Left(strTextToConvert, 1)) & LCase(Mid(strTextToConvert, 2))
 
Back
Top