Capitalise first letter of each word

[drschlong]

Hi all,

This probably sounds like an easy question.

I have a field which users enter Contact Names into. If a user enters for example "mr jones" I would then like the field to change to "Mr Jones" or if they wrote "mr bill smith" it would change to "Mr Bill Smith" when they tabbed or clicked in the next field on the form.

There is bound to be an easy answer to this so any help would be much appreciated.

Thanks in advance,

Steven.

 

[antomack]

Check help for StrConv.