about column value in table

  • Thread starter Thread starter Lei
  • Start date Start date
L

Lei

There is a name field in my table. some of the values are
in lower case, some in upper case or mixed case. Is there
any way to convert all the name value in a format with
first letter in upper case and the rest letters in lower
case automatically withour coding?

Thanks!
 
Use an update query.

1. Create a query into the table.

2. Drag the name row into the grid.
For this example, we assume it's called "MyNameField".

3. Change it to an Update query (Update on Query menu).
Access adds an Update row to the grid.

3. In the Update row under this field, enter:
StrConv([MyNameField], 3)

4. Run the query.

You will have to manually sort out names like McDonald, O'Brien, van Leen,
....
 
Allen,

Thank you very much!

Lei
-----Original Message-----
Use an update query.

1. Create a query into the table.

2. Drag the name row into the grid.
For this example, we assume it's called "MyNameField".

3. Change it to an Update query (Update on Query menu).
Access adds an Update row to the grid.

3. In the Update row under this field, enter:
StrConv([MyNameField], 3)

4. Run the query.

You will have to manually sort out names like McDonald, O'Brien, van Leen,
....

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

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

There is a name field in my table. some of the values are
in lower case, some in upper case or mixed case. Is there
any way to convert all the name value in a format with
first letter in upper case and the rest letters in lower
case automatically withour coding?

Thanks!
Click to expand...


.
Click to expand...
 
Back
Top