Change case from caps to title

[Guy Delaney]

When my data was input into my Access database, it was all capitalized. How
can I change this to title case?

 

[Steve Schapel]

Guy,

Run an Update Query on the table, to update [YourField] to:
StrConv([YourField],3)

 

[Allen Browne]

When my data was input into my Access database, it was all capitalized.
How can I change this to title case?

Use an Update query.

1. Create a query using your table.

2. Change it to an Update query (Update on Query menu.)
Access adds an Update row to the query grid.

3. In the Update row under your field, enter:
StrConv([MyField], 3)
substituting your field name for MyField.

4. Run the query.

You will have to manually sort out names such as McDonald.

 

[Wayne-I-M]

Hi

You can usethis

UPDATE TableName SET TableName.FieldName = StrConv([TableName]![FieldName],3);


"Make a back up your database" (important when running an update query)

Create a query
Change it to an Update query
Add the Field to the grid that you want to change
Add this to the UpDateTo row StrConv([TableName]![FieldName],3)
Run the query

Hope this helps