I am learning to use Access 2003. I want the database to automatically
capitalize the 1st letter of the last and first name.
Here's some VBA code I use in the AfterUpdate of each textbox for which you
want this to happen. It checks first to see if the user has already input
mixed case, so as not to mess up correctly capitalized names such as
"O'Brien", "McDonald" and "van der Steen".
Private Sub textboxname_AfterUpdate()
If StrComp(Me!textboxname, LCase(Me!textboxname), 0) = 0 Then
Me!textboxname = StrConv(Me!textboxname, vbProperCase)
End If
End Sub
John W. Vinson [MVP]