Uppercase

[Chum]

The table has a field which lists the titles of books. Only the first letter of the first word is uppercase. How can I change each word's first letter to uppercase?

 

[Mike375]

Create a claculated field in a query as follows

NewFieldName:StrConv([abc],3)

where [abc] is the name of the field that has your data.

You can then either use the new field in a form or just copy and paste back into the field that has your data.

 

[jwhite]

Mike's got the answer for ya right there. If you want to update your entire table, use that field in your SELECT query and convert it to an UPDATE query. But, BACKUP YOUR DATABASE FIRST.