Table Input mask to capitalize the first letter of each word.

[MikeFL]

Is there an Input Mask that I can use in my Table that will capitalize the first letter of each word in a company name or persons name with-out the user having to do this them selves during data entry (e.g., The Work Company Inc., Mc Gregory Inc. Michael Eisner, Tom Mc Crackle, etc.)?

Or do I have to do this in a Query before displaying it in a form?

If it has to be performed in a Query, how would I do it (enter it), and would I put it in the Criteria Field of the name I wanted to change in the Query, or make a new field in the Query?

I'm stumped!

 

[PHV]

Have a look at the StrConv function:

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dhookom]

The mentioned "StrConv()" function can be used in a query or in the After Update event of a control on a form.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[MikeFL]

Thanks MVP & Dhookom, your suggestions worked!