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

  • Thread starter Teddy via AccessMonster.com
  • 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
 
J

John Webb via AccessMonster.com

Hi, this would do the job:

= StrConv("TextToConvert",vbProperCase)

Cheers

John Webb
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert list to UPPER, lower & Proper cases. 21
Copy each data record of a name list and place it under the onecopied 2
test first character to see if it is lower case using vba 5
[VBA] Get the content of each value of a line 8
How to change character to lower case except the first letter? 2
First Character to Lowercase 2
How to delete a "return" character (a "box") in cell of imported d 1
Capitals at the beginning of a line 1

Top