How to automatically capitalise text box Follow



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



Peter Thane
Comment actions Permalink

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


Please sign in to leave a comment.