Easy String Manipulation Question

[sandraX]

I need a function that returns a string to the page with the first letter capitalized when it is fed an all-lowercase string. Anyone know how to do this?

 

[JohnYingling]

Look at STRCONV function
strCap = strConv(strIn,3) ' 3=vbProper capitalize 1st leter of every word
OR

Function Capital1st(strIn as string) as string
    If Len(strIN) > 0 then
        Captial1st = Ucase(Left(strIn,1)) & Mid(strIn,2)
    else
        Capital1st = strIn
    end if
End function

http://WWW.VBCompare.Com

 

[sandraX]

Thanks a bunch, John! That is exactly what I needed!