Is there a way, and perhaps a simple way to dynamicly change the size of a field based on the amount of text that is within it?
The reason that I would like to have the size of the field adjust to the data within it is for reporting. I have one field that will vary in greatly in it's content from perhaps (15) words to (50) words. Having a set size of field is a bit of a waste of space if I can reduce it I would like too.
Thanks in advance,
The best that you can acheive is by making the field large enough to fit the 50 words (or more) on the layout, then use the sliding & visibility options, choosing to 'remove blank space' options (see pict)
- this will work when printing or previewing the text. Sliding objects left and 'resize enclosing part' should be good enough for most reports.