string convert

[malcolmmabe]

what is the code the converts a string to leading
capitals, i.e mr malcolm mabe - Mr Malcolm Mabe?

 

[Karen]

Malcolm,

I use

StringToConvert= StrConv(StringToConvert, vbProperCase)

 

[Ron Weiner]

strconv("mr malcolm mabe",vbProperCase) ought to get it done.


Ron W

 

[Pavel Romashkin]

Try Propercase function.

Pavel