How do I use VB to capitalize the first letter in a word?

hart116 · Jul 29, 2005

How do I create a procedure to convert a field values to proper case?
(Capitalize the first letter of each word, and convert all others to lower
case) I.E. Nova Scotia, Prince Edward Island ..etc.

Graham R Seach · Jul 30, 2005

Check the online Help for StrConv().
MsgBox StrConv("prince edward island", vbProperCase)

....or there's this:
http://www.pacificdb.com.au/MVP/Code/ProperCelt.htm

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
(Currently in Japan)

How do I use VB to capitalize the first letter in a word?

hart116

Graham R Seach