Capitalization code Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi any one with an Idea how to write code that capitalizes the first letter
of every word and one that capitalizes the whole statement. Very much
appreciated
 
The StrConv function should be what you are looking for. Look it up in the
help file for all the details.
 
UCase() will convert a string to all upper case.

Alternatively you can use the StrConv() Function:

StrConv(MyString,vbUpperCase) 'convert to upper case
StrConv(MyString,vbProperCase) 'capitalize first character of each word

Steve
 
Back
Top