proper case string conversion 2

[onetomany]

Is there a VB function that will convert a string to proper case i.e. "holly grow" is converted to "Holly Grow". similar to the ucase and lcase functions.
I am almost positive that I have used this before but I cannot remember the function name.


thanks

 

[Jon4747]

Hi,

Dim str As String, str1() As String, strR As String
str = "does this help"
str1() = Split(str, " &quot
For intA = 0 To UBound(str1)
strR = Left(str1(intA), 1)
str1(intA) = Replace(str1(intA), strR, UCase(strR), 1, 1)
Next
str = Join(str1(), " &quot
Debug.Print str

Jon

 

[fenris]

Try:

StrConv("this is a test", vbProperCase) Troy Williams B.Eng.
fenris@hotmail.com

 

[onetomany]

thanks to the both of you.
that is exactly what i was thinking of fenris.

 

[dsi]

Like Jon, I too wrote a routine for this. Well, I learned my somthing today. Guess I should call it a day. X-)