How to Automatically Change Text to Title Case in Microsoft Access

APPLIES TO: ACCESS 2007, 2010 (UNTESTED IN EARLIER VERSIONS)

(also known as change text to proper case)

The following tutorial shows you how you can use VBA to set a field in your form so that regardless of how a user enters text in a field on a Microsoft Access form it will be automatically formatted with the first letter of each word in title case.

1. Select the field you want to use

2. In the tools section of the “Design” tab click on the item called “Property Sheet”

3. Select the “Event Tab”

4. On the “After Update” property click on the little black down arrow / triangle

5. Select “Event Procedure”

6. Click on the three dots next to the little black down arrow / triangle – this will open up the VBA window and you should see the following:

Private Sub YourFieldName_AfterUpdate()

End Sub

(The text “ YourFieldName” straight after the words “Private Sub” will have automatically been replaced by the name of the field you are using)

7. On a new line directly between the two lines above add the following:

YourFieldName = StrConv(YourFieldName, vbProperCase)

(Replacing the text in red “YourFieldName “ with the name of your field).

8. Save your changes and test your form / report

Note: The text changes only once the user has finished entering data and clicked away from the field.