How can I force upper then lower case characters when inputting a.

R

Rick B

What about McDaniel?

This is not recommended.

If you will search previous posts you will find many many threads that
address this issue.
 
J

John Vinson

Sheridan said:
name into a table in MS Access?
Click to expand...

As Rick says - not necessarily a good idea!

You'll need to use a Form to do this; you can put the following VBA code
into the AfterUpdate event of the textbox. I'll call it txtLastName:

Private Sub txtLastName_AfterUpdate()
' only mess with names that are currently all lower case
If StrComp(Me!txtLastName, LCase(Me!txtLastName), 0) = 0 Then
Me!txtLastName = StrConv(Me!txtLastName, vbProperCase)
End If
End Sub

This will let the user type in "McDaniel" or "van Cleef" and have it left
alone. However, e. e. cummings will be converted in a way which the poet
would not have liked.

John W. Vinson [MVP]
 
Top