Capitalization - only first letter of word

  • Thread starter Thread starter Kathy MacAthur
  • Start date Start date
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
 
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)
 
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...
 
Back
Top