Changing all Caps in a column

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I am fairly new to Access and am not familiar with how to change the case
within a column.

I have a database of 300K records and one of the fields the entire column is
all capitals. I want to convert the text to make it proper where the first
letter of each word is capitalized.

I appreciate your help and look foward to your input / advice.
 
Jeff,

Make sure you have a backup of the database.

Make a query based on the table, and add the field in question to the query
design grid.

Make it into an Update Query (via the Query menu, unless you have Access
2007).

In the Update To row of the query design grid, enter the equivalent of:
StrConv([NameOfYourField],3)

Run the query (click the red [!] icon on the toolbar/ribbon.
 
I am running Access 2007 and am unsure as to where to type the commandyou
suggest
--
Thanks in advance for your help
Regards,
Jeff


Steve Schapel said:
Jeff,

Make sure you have a backup of the database.

Make a query based on the table, and add the field in question to the query
design grid.

Make it into an Update Query (via the Query menu, unless you have Access
2007).

In the Update To row of the query design grid, enter the equivalent of:
StrConv([NameOfYourField],3)

Run the query (click the red [!] icon on the toolbar/ribbon.
Click to expand...
 
Jeff,

In Access 2007, you make a query via the Create=>Query Design ribbon button.
Add the requisite table to the query. Then to make it an Update Query, you
should see an 'Update' button on the 'Query Type' tab of the query design
ribbon.
 
Back
Top