Technology Training Community

I was recently asked if it is possible to change the case of the text in an Access database. The answer is yes. Using the function, LCase and UCase, the text in a field can be changed to all lowercase or all uppercase. LCase converts all uppercase letters in a text string to lowercase. UCase converts all lowercase letters in a text string to uppercase. If you want to convert the text to proper case, where each of the word’s first letter is capitalized, you can use the StrConv function.

Example:
Field1 = the Dog Is biG

LCase([Field1]) returns the dog is big
UCase([Field1]) returns THE DOG IS BIG
StrConv([Field1],3) returns The Dog Is Big