Capitalization - only first letter of word

K

Kathy MacAthur

Hi everyone:

I've been using a string conversion StrConv ([field_to_convert],3) and it
capitalizes the first letter and makes the rest of the characters in each
word lowercase. Is there a way to capitalize the first letter but leave the
rest of the characters as they were originally typed. I am using this for
addresses and info like APO and PO Box are coming out Apo and Po Box. Any
suggestions.

Thanks in advance,

Kathy
 
B

Brian

Kathy MacAthur said:
Hi everyone:

I've been using a string conversion StrConv ([field_to_convert],3) and it
capitalizes the first letter and makes the rest of the characters in each
word lowercase. Is there a way to capitalize the first letter but leave the
rest of the characters as they were originally typed. I am using this for
addresses and info like APO and PO Box are coming out Apo and Po Box. Any
suggestions.

Thanks in advance,

Kathy
Click to expand...

Ucase(Left(field_to_convert),1) & Mid([field_to_convert],2)
 
K

Kathy MacAthur

Thanks Brian!

Brian said:
Kathy MacAthur said:
Hi everyone:

I've been using a string conversion StrConv ([field_to_convert],3) and it
capitalizes the first letter and makes the rest of the characters in each
word lowercase. Is there a way to capitalize the first letter but leave the
rest of the characters as they were originally typed. I am using this
for
addresses and info like APO and PO Box are coming out Apo and Po Box.
Any
suggestions.

Thanks in advance,

Kathy
Click to expand...

Ucase(Left(field_to_convert),1) & Mid([field_to_convert],2)
Click to expand...
 
Top