Cap second a third word

[Ielamrani]

Hi,
Hi,
I don't know if there is an aswer to this issue but I am going to ask anyway.
I know how to capitalize the first letter of a word when entered in text box.
Is there a code to cap the first letter of the second and third of word?

Example:

If a user enter in text box: i love soccer.
it should turn to: I Love Soccer.

Thanks in Advance
Ismail

 

[Lilliabeth]

Put this in the after update event of the control

Private Sub txtControlName_AfterUpdate()
Me!txtControlName = StrConv(Me!txtControlName,vbProperCase)
End Sub

 

[Lilliabeth]

Wow, here is a fancy one!

http://www.tek-tips.com/faqs.cfm?fid=659

 

[Ielamrani]

Great, Thank you.
Ismail