Change all uppercase to upper & lower case in Access

B

Becky

My data is all uppercase, but my boss prefers letters to go out in upper and
lowercase. Just need help in doing this.
 
P

Pat Hartman \(MVP\)

The strConv() function will do this for you although you might not like the
results. Due to the variations in how people like to see their names, it is
unwise to store them as uppercase since it is virtually impossible to come
up with a perfect upper case to proper case conversion.
 
J

Jerry Whittle

Debug.Print StrConv("HAPPY EASTER",3) returns Happy Easter. 3 = vbProperCase.

Debug.Print StrConv("HAPPY EASTER",2) returns happy easter. 2 = vbLowerCase.

Debug.Print LCase("HAPPY EASTER") returns happy easter.

Debug.Print Left(UCase("HAPPY EASTER"),1) & Mid(LCase("HAPPY EASTER"),2)
returns Happy easter.
 
D

Daniel

Look in the string class in the VBE. You will see numerous options. Since
you don't give an example of what you need as an output I will list the most
common.

Ucase() - converts a string to uppercase
Lcase() - converts a string to lowercase
StrConv() - converts a string to various formats
StrConv(YourString,vbUpperCase) - ALL UPPERCASE
StrConv(YourString,vbLowerCase) - all lowercase
StrConv(YourString,vbProperCase) - All Propercase
and more look it up in the help file
 
Top