L
Lauri
Anyone know mask to do this? I'm a beginner here. Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Ken Snell
One way to do this (although it's not foolproof) is to use StrConv function
in code that is run in the AfterUpdate event of the textbox:
Private Sub txtBoxName_AfterUpdate()
Me.txtBoxName.Value = StrConv(Me.txtBoxName.Value, vbProperCase)
End Sub
Note that this will capitalize the first letter of each word, which may not
give the right results for nonstandard names:
rosemarie will become Rosemarie even if it should be RoseMarie
etc.
in code that is run in the AfterUpdate event of the textbox:
Private Sub txtBoxName_AfterUpdate()
Me.txtBoxName.Value = StrConv(Me.txtBoxName.Value, vbProperCase)
End Sub
Note that this will capitalize the first letter of each word, which may not
give the right results for nonstandard names:
rosemarie will become Rosemarie even if it should be RoseMarie
etc.