Ucase first character of string

[Guest]

I have imported a table of names, addresses, etc that are all upper case. I
have converted everything to lowercase but now need to change the first
letter of each string to uppercase. How???

steve

 

[Allen Browne]

Use StrConv() in an Update query.

1. Create a query using this table.

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

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

4. Do the same thing for the other fields that need converting.

5. Run the query.

You will have some manual cleaning up to do.

BTW, that converts the first letter of each word to upper case.
If you just wanted the first letter of the field, use:
Left([Surname],1) & StrConv(Mid([Surname], 2, 2)

 

[Guest]

Thanks Allen. That is exactly what I needed. I have 3 books on Access and
none of them have a reference to all the functions available. Where can I
find a good reference with examples. When I use the builtin help for access
and type in Strconv I get a very confusing explaination about ANSI vs unicode
characters.

Steve

Use StrConv() in an Update query.

1. Create a query using this table.

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

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

4. Do the same thing for the other fields that need converting.

5. Run the query.

You will have some manual cleaning up to do.

BTW, that converts the first letter of each word to upper case.
If you just wanted the first letter of the field, use:
Left([Surname],1) & StrConv(Mid([Surname], 2, 2)

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

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

I have imported a table of names, addresses, etc that are all upper case.
I
have converted everything to lowercase but now need to change the first
letter of each string to uppercase. How???

steve

 

[Please Help Me]

This should capitalize the first letter of the entire string and leave the
rest unchanged....
StrConv(Left([MyField],1),3) & Mid([MyField],2)

Thanks Allen. That is exactly what I needed. I have 3 books on Access and
none of them have a reference to all the functions available. Where can I
find a good reference with examples. When I use the builtin help for access
and type in Strconv I get a very confusing explaination about ANSI vs unicode
characters.

Steve

Use StrConv() in an Update query.

1. Create a query using this table.

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

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

4. Do the same thing for the other fields that need converting.

5. Run the query.

You will have some manual cleaning up to do.

BTW, that converts the first letter of each word to upper case.
If you just wanted the first letter of the field, use:
Left([Surname],1) & StrConv(Mid([Surname], 2, 2)

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

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

I have imported a table of names, addresses, etc that are all upper case.
I
have converted everything to lowercase but now need to change the first
letter of each string to uppercase. How???

steve