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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simple update query question 3
how to convert uppercase to proper name using update query 4
Title or Proper Casing Text in Access 3
Another case sensitive query 2
How to determine if field is all uppercase? 2
query returns uppercase data 6
Update any Mcsmith to McSmith, etc . . . 5
Change Upper Case to Proper Case 5

Back
Top