Capturing that field is ’filled to overflowing’

[lorveney]

Apologies if this has been asked before …. I have not been able to find an answer for it in the forums.

I have a fixed format, single page, report with many fields on it, several of which are Memo fields. On some occasions, the report field is insufficiently sized to take all the text and I would like to be able to capture when this happens and perhaps put an asterisk in the box and show the full text on a second page (something similar to this, anyway, the point being I want to be able to identify that this has happened and reformat the report in some way).

I can capture that this has happened by setting the report field’s Can Grow property to Yes and in the Detail_Print event check whether the field’s height is greater than the norm. Unfortunately, by this stage, it is too late to reformat the report.

If I move the check to the Detail_Format event, it doesn’t detect the change as the field hasn’t grown in size at this stage.

Is there a way of detecting whether a text box on a report is ’filled to overflowing with text' at an early enough stage to be able to keep the field 'ungrown' but indicate that this has happened on the report?

Many thanks in advance.

 

[Rabbie]

One way might be to work out out the max length you can display in the text box and Check the length of the actual string when out putting the record. You would need to write some VBA to handle this.

 

[lorveney]

Hi Rabbie, Won't that vary depending on the text e.g. wont IIIIII take up less space than XXXXXX?

 

[Rabbie]

That will depend on the font you are using. Iam afraid that is the best I can come up with to help you