Convert the lowerc ase first letter in a Name to upper letter.
HI All,
I've a text control that allows a user to type in their name. How do I convert their first letter of their name in lowercase to uppercase automatically, soon as they tab to the next field.
Thanks in advance!
Beth
Re: Convert the lowerc ase first letter in a Name to upper letter.
Assume your text box name is "Text1".
private Sub Text1_LostFocus()
Dim strTemp as string
strTemp = Text1.Text
mid(strTemp, 1, 1) = UCase(Left(Text1.Text, 1))
Text1.Text = strTemp
End Sub
Re: Convert the lowerc ase first letter in a Name to upper letter.
Text1 = StrConv(Text1, vbProperCase)
David Paulson