Capitalize Text

  • Thread starter Thread starter DavidW
  • Start date Start date
D

DavidW

Is there a way through code to capitalize the first letter in what someone
enters in a text box. I have used what Access has included but some of what
gets put in is not recognized by access.
And is there a way to capitalize every letter put into a box
 
To capitalize every letter, use the UCase function.

To capitalize only the first letter, use UCase(Left(MyString, 1)) &
LCase(Mid(MyString, 2))

To capitalize the first letter of each word, use the StrConv function with
an argument of vbProperCase (3 if you're doing this in a query):
StrConv(MyString, vbProperCase)
 
Back
Top