How to automatically capitalise text box
Hello,
I have a number of text boxes that I am using to pull addresses from a spreadsheet of orders, I would like to if possible be able to make it so I would be able to capitalise the first letter of each word for example at the moment I have:
14 church road
and would like it to instead display: 14 Church Road
Is this possible? If not is it possible to capitalise the whole string, for example: 14 CHURCH ROAD
I know I can do this outside of the software, but would rather have it set up so I don't have to modify the spreadsheet with the order details each time
Thanks
-
You would probably need to write some complex VB to achieve the former option but converting everything to upper case is simple as you can enable this from the Character Filter option on the Transforms tab
0
Please sign in to leave a comment.
Comments
1 comment