I am learning to use Access 2003. I want the database to automatically
capitalize the 1st letter of the last and first name.

On Fri, 4 Jan 2008 08:45:01 -0800, Sol wrote:

> I am learning to use Access 2003. I want the database to automatically
> capitalize the 1st letter of the last and first name.

Using a form for the data entry, code the AfterUpdate event of the
FirstName control to:

Me![FirstName] = StrConv([FirstName],3)

Do similar code in the LastName AfterUpdate event as well.

Note: this will improperly capitalize any name that normally should
have more than one capital, i.e. O'Brien, McDonald, Smith-Young, etc.
and also incorrectly capitalize names that should not be capitalized,
i.e. van den Steen, etc.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

On Fri, 4 Jan 2008 08:45:01 -0800, Sol <(E-Mail Removed)> wrote:

>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]