D Duane Hookom Jul 16, 2006 #2 Could you explain with some examples? The StrConv() function might work for you. When/where do you want this "force" to occur?
Could you explain with some examples? The StrConv() function might work for you. When/where do you want this "force" to occur?
L LJG Jul 16, 2006 #3 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
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 Jul 16, 2006 #4 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)
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)
