Correct Title Case

[LJG]

Hi Guys,

Is it possible to force a text field to correct title case?

TIA

 

[Duane Hookom]

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

 

[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

 

[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)