Change Between UPPER, lower, and Proper Case in your Microsoft Access Databases

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?

BONUS FOR MEMBERS:
Silver Members and up get access to an Extended Cut of this video. Members 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.

MEMBERS VIDEO:

BECOME A MEMBER:

LEARN MORE:

LINKS:

COURSES:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, 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

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[josephmessina]

I like that video on case change in Access. I didn't know if everything in a database in access shluld be all capitalized. I'm glad you made that video. I thouhgt databases were all capitalized. I didn't know that until you made that video should be proper case. It helps. Now i can change my databases to convert from all upper case to proper case.

[aminam]

Tank for Your Knowledge Sharing, Unfortunately, We Cant by Your Join Members, But Learned a lot From Your Free Training, Thanks

[stephenbeswick]

Hi Richard I use feature when customer service call are made which is grate but I use after update function which very good. Another grate video I will some of these functions in my customer services database. Steve B.

[sarahberkner]

I appreciate the Star Trek reference.
And the tutorial of course.

[fransmith]

Hi. This looks easy. But I'm writing a second language app for teaching English to beginners. I have a "words" table, and all the words are, or course in lower case, because that's how they're used most of the time. However, I'm testing my students on sentences, so when a word is used to start a sentence, it requires upper case. I have my form with a lot of combo boxes, one for each word of a sentence. Students listen to the sentence, then make the sentence on the form. I have 13 comboboxes all populated with the words that they know in all lower case (except for words like "English", which is always proper case). But I want just that first combobox to convert the words to proper case when it populates the combobox. I've found a way to change the word to proper case using code AFTER the combo box is populated and they've chosen the word, " Me.CmbWord1 = StrConv(Me.CmbWord1, vbProperCase)", but I can't work out how to convert the words to proper case BEFORE the box is populated from the row source. I'd rather the students always see their selection in that first box as proper case, instead of waiting until they choose one and they seeing it change, and I don't want to have to add a second column of words just for the first combobox. I tried all sorts of things to convert what you're doing into populating the form instead of a query, but it doesn't work. Is there a way?

Thanks in advance.

[xSavageGamerx]

HOw do i do the UCASE in afterupdate in data entry

[punkysteve]

Hi, great vid cheers, but... I see you are making additional columns of UC, LC and PC to the table, how do you change the "Last name column" in the table to show the case you want?

[gregqualtieri]

Will numbers affect the function like in the address or email, love the videos going to join today