formatting text field - 1st letter of every word is Capital letter

[Harrold]

Hi

Is it possible to format the text field in a way that all first letter of the words is to be capital letter? If so, please guide me how to do it?

Thanks

 

[jonathanchye]

Hi

Is it possible to format the text field in a way that all first letter of the words is to be capital letter? If so, please guide me how to do it?

Thanks

Yes, by using an Input mask. Try <L>CCCCC. < automatically filters the next character to a capital and > does the opposite. L forces user to enter a letter while C means users can enter up to 5 characters or spaces.

Have a look here : http://office.microsoft.com/en-us/a...try-formats-with-input-masks-HA010096452.aspx

 

[DCrake]

Better to use

Me.TextBox = StrConv(Me.TextBox,vbProperCase)

 

[Harrold]

Hi DCrake,

Where should i put it? Input mask?

Thanks

 

[DCrake]

No, in the before/after update event of the control.