Hello,

I have a number of text boxes on a data entry sheet that transpose onto a report template once the report is generated.

Now i know I can restrict the number of characters using the "Max Length" property but what i need to do is restrict the number of characters to the actual size of the text box. (No scrolling etc, what you see on the screen is what is transposed to the report.

Is this possible and does anyone have any ideas

Many thanks