Proper Case

  • Thread starter Thread starter APH
  • Start date Start date
A

APH

Hi, I have some data that is all in uppercase. how do i change it to Proper
case. - thanks

Alex
 
1. Create a query into this table.

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

3. Assuming the field is named "MyField", enter this into the Update row
under this field:
StrConv([MyField], 3)

4. Run the query.

5. Manually sort out the names that get messed up such as McDonald.
 
Thanks Allen
Allen Browne said:
1. Create a query into this table.

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

3. Assuming the field is named "MyField", enter this into the Update row
under this field:
StrConv([MyField], 3)

4. Run the query.

5. Manually sort out the names that get messed up such as McDonald.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

APH said:
Hi, I have some data that is all in uppercase. how do i change it to Proper
case. - thanks
Click to expand...
Click to expand...
 
Back
Top