|
||||||
|
Change Case By Richard Rost ![]() ![]() Change Between UPPER, lower, and Proper Case In this Microsoft Access tutorial, I will teach you how to convert strings (such as names) to UPPER CASE, lower case, and Proper Case. You will learn how to use the StrConv function in your queries. We'll create an update query to change all of the names in your customer table. Mira from Hamburg, Germany (a Gold Member) asks: My people are horrible at data entry. Half of them type in ALL CAPS and the other half don't know where the Shift key even is. I've got names of all kinds in my Customer table. How can I clean this up? MembersMembers will learn how to create a MyProperCase function which will convert names that have been typed in all caps or all lowercase, but will leave names that already have mixed case in them alone, such as McDonald or D'Angelo.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today! Links
Proper Case
|
||||||||||||||||||||||||||||||||
| |||
Keywords: TechHelp Access uppercase, ucase, upper-case, upper case, lowercase, lcase, lower-case, lower case, propercase, pcase, proper-case, proper case, strconv, strcnv, mixed case, mixed-case, convert, string, function PermaLink Change Case in Microsoft Access |