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

[Guest]

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]

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)