Capitalization code Help

M

Muriukis

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
 
D

Daniel

The StrConv function should be what you are looking for. Look it up in the
help file for all the details.
 
S

SteveM

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
 
Top