I have enjoyed your lessons very much.  I have created a simple date base to record patient charts in storage.  Some staff entering information have not capitalized names.  Is there a way to force either all caps or at least first letter caps. I am finding the non caps are not in ABC order. Also can I write a query to look for those errors to correct them.

---

Reply from Richard Rost:

There are a couple of ways you can do this. You can use the INPUT MASK property to force characters to upper case as they're entered:

>CCCCCCCCCCCCCC

You could also use the UCASE function in an AfterUpdate event for your form field to perform the conversion too. I generally go with this route.

You can use something called PROPER CASE to make the first letter of each WORD capitalized. That's a bit more tricky. I cover that in Access 222.

As far as fixing all of the records you currently have, that's possible with the UCASE function again, and an UPDATE QUERY.