Change case from caps to title

G

Guy Delaney

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

Steve Schapel

Guy,

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

Allen Browne

Guy Delaney said:
When my data was input into my Access database, it was all capitalized.
How can I change this to title case?
Click to expand...

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.
 
W

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
 
Top