Capitalize Text

[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

 

[Douglas J. Steele]

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)