Text Box Control

[matthew]

Hi just trying to make my app behave better but that needs me to be able to control the size of text boxes otherwise the information will quickly get out of control and the diagram become unreadable.  I'm struggling with determining how I do that for these scenarios:
1.   If I set the size of a text box, how do I make sure that when the text string is too long, it is limited to the number of characters that fits the box?  I know one way would be for me to show only x characters but how do I know how many characters that is when it can include upper and lower case (and when the font can vary each time (though the size is the same))?  Is there a Visio setting that would do this automatically?
2.   If I add a text box, is there a way for the text box to automatically size itself without going on to a new line?  That is, increase it's width to the size required.
3.   Is it possible to allow the text box to automatically adjust within a maximum height and width that I set?  If it can be smaller (when there isn't much text) then it would be but it would be no bigger than the constraints I apply.
Can someone point me in the right direction please?
kind regards
Matthew

[Paul Herber]

Have a look at my:
https://www.paulherber.co.uk/stuff-about-visio/
in the 'various formula' section.

[wapperdude]

Also, look at this post wrt to text scaling based upon amount of text
http://visguy.com/vgforum/index.php?topic=8651.msg37735#msg37735/

Some additional background info:
http://www.visguy.com/2007/08/21/text-resizing-with-shapesheet-formulas/

[matthew]

thanks to both Paul and wapperdude, there is a lot of information in here so I'll take the time to go through it and see if I can apply it to my needs, many thanks
Matthew