I want first letter to show capitalized

[Ryan]

How do I make it so the first letter is capitalized and others are lowercase:
Ex. Billy Bob --even when typed in with all lowercase?

Do i adjust in table or in form and what do I do?

 

[Linq Adams via AccessMonster.com]

In the code module for your form

Private Sub YourTextBox_AfterUpdate()
Me.YourTextBox = StrConv(Me.YourTextBox, vbProperCase)
End Sub

Just be aware that this may give you some unexpected results if you're
actually using it for entering full names into one textbox/field.

While

billy bob

will become

Billy Bob

billy bob III (the 3rd)

will become

Billy Bob Iii

Each component of a name (first name, last name, qualifier) really should be
in a separate field, concatenating them as need be for display.

 

[Clifford Bass]

Hi Ryan,

And DeAnna, typed as deanna will become Deanna. And McDonald will be
Mcdonald, and so on and so on. If this is new entry of text is best to have
the names typed exactly as the person desires. If after the fact, do an
update and then manually fix those that need fixing.

Clifford Bass