How to Format the Proper Case in MS Access 2003

There are two ways to format text into the proper case in Access 2003. Both require the user to enter code into a query. Creating a module allows users to enter other commands, code and multiple case formats as needed for their particular database. A simple SQL statement can change the text into the proper case with a lot less coding.

Instructions

1. Open the query you want to change the text format in.

2. Click the "Design View" icon.

3. Click the "Close" button if the Show Table dialog box opens.

4. Select the "SQL" option from the View menu.

5. Type "SELECT tblFieldName, STRCONV(tblFieldName,3) as Proper_Case FROM TableName"

   tblFieldName = the name of the field you want to convert

   3 = format type; the 3 is for Proper Case, 1 = ALL CAPS, 2=no caps

   Proper_Case=Just a temp field name you are placing in the query

   TableName=The name of the table where the field is that you are getting the information from

References

• Microsoft: How to Convert Data Values to Proper Case

Resources

• Microsoft: How to Convert Data Values to Proper Case Access 2000/2002