capital letters

[accesshelp]

Hi.

I need help in capitalize the first letter of the set of words.
For example, if i enter jonh smith the output should be John Smith...so it dosen't matter how many characters or how many words i enter...

is this possible? if so what code should be in input mask?



Please help me out...

[Vera]

You can use vbProperCase - Converts the first letter of every word in string to uppercase.

Use it in an after update event for instance.

Private Sub Text0_AfterUpdate()
Me.Text0 = StrConv(Me.Text0, vbProperCase)
End Sub

Only problem is names like McGregor, names with two capitals in it. Don't know how you can tackle this.