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

  • Thread starter Thread starter Guest
  • Start date Start date
What about McDaniel?

This is not recommended.

If you will search previous posts you will find many many threads that
address this issue.
 
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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Differences between lower case and upper case 4
Lower-Case Characters 2
Force upper case 4
How do I force upper case in an Access field in a form or a query. 7
Change from all UPPER case letters 5
Force Lower Case 3
Change all upper case letters to lower case 2
Change text from lower case to upper case in Access 2007 1

Back
Top