vba convert a the first character of each word of a string entered from lower ca

  • Thread starter Thread starter Teddy via AccessMonster.com
  • Start date Start date
T

Teddy via AccessMonster.com

Hello, Experts,

I am new to Access Programming. Could you please tell me how to use vba
code to automatic convert the first character of each word from lower case
to upper case ( Like user enter new york city, after formatting becomes New
York City). Thank you in advance!

Regards,

Teddy
 
Hi, this would do the job:

= StrConv("TextToConvert",vbProperCase)

Cheers

John Webb
 
Back
Top