Change data from ALL CAPS?

[Kathleen Atkins]

I have 2,000 records (name, address, etc) where the data is all in upper
case. I would like to change it to the standard upper case, lower case
format. (First letter capitalized for each word, remaining lower case).

Is there a command in Access 2003 I can use to make this change throughout
the table? I don't have the time to edit each entry.

Thanks for any suggestions.

 

[Arvin Meyer]

You can do it all with a single update query:

UPDATE MyTable SET MyTable.MyField = StrConv([MyField],3);

substituting your table and field names, of course.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Kathleen Atkins]

Arvin-

I'm new to this. The table has 13 fields of data that need editing. Would I
list all field names? Or run the query 13 times, each time changing the
MyField value?

Thank you.

You can do it all with a single update query:

UPDATE MyTable SET MyTable.MyField = StrConv([MyField],3);

substituting your table and field names, of course.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

I have 2,000 records (name, address, etc) where the data is all in upper
case. I would like to change it to the standard upper case, lower case
format. (First letter capitalized for each word, remaining lower case).

Is there a command in Access 2003 I can use to make this change
throughout
the table? I don't have the time to edit each entry.

Thanks for any suggestions.

 

[Arvin Meyer]

You can do it either way. It would take about the same amount of time to
write it either way, but you'd only have to run it once if you did them all.
Personally, I'd probably run them one at a time, for the first 3 or 4, then
I'f get bored and run the rest of them all at once.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Arvin-

I'm new to this. The table has 13 fields of data that need editing. Would I
list all field names? Or run the query 13 times, each time changing the
MyField value?

Thank you.

You can do it all with a single update query:

UPDATE MyTable SET MyTable.MyField = StrConv([MyField],3);

substituting your table and field names, of course.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

I have 2,000 records (name, address, etc) where the data is all in upper
case. I would like to change it to the standard upper case, lower case
format. (First letter capitalized for each word, remaining lower case).

Is there a command in Access 2003 I can use to make this change
throughout
the table? I don't have the time to edit each entry.

Thanks for any suggestions.