Correct Title Case

D

Duane Hookom

Could you explain with some examples? The StrConv() function might work for
you. When/where do you want this "force" to occur?
 
L

LJG

For product names on invoice, as the users enter the data in both upper and
lower case, so invoices look untidy at times.

So rather than get them to tidy the naming, of products, use formatting to
ensure consistency

Current:
condensed milk
bechamel sauce mix

Preferred
Condensed Milk
Bechamel Sauce Mix

Thanks
 
D

Duane Hookom

You can use
=StrConv([YourField],3)
if you are only interested in formatting output.
If you want to store the results fo StrConv(), consider adding code to the
After Update event of the text box:

Me.txtYourField = StrConv(Me.txtYourField, 3)
 
Top