First Letter Uppercase

R

roselaurel

I'm creating a database to help my son track his collectors cards. He's only
nine and doesn't always hit the shift key to put a players name in properly.
How can I format a text field to automaticly capitalize only the first letter
typed? Also is there some way to do the same thing in a memo field with the
first letter of a sentence? This seems like such an 'obvious' formating
function I can't believe there isn't a way. Thanks for whatever help you can
give.
 
B

Bob Barnes

Assign this to the AfterUpdate for the field (NOTE...McDonald will be
Mcdonald)..

Sub MyField_AfterUpdate()
MyField = StrConv(MyField, vbProperCase)
End Sub

Hope this helps - Bob
 
Top