Text Box Truncation -- detect it?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

William Bub - 13 Mar 2007 02:28 GMT

If I put a text box on a report and fill it with text which may be a short
line or a long line, and I set the property to CanGrow=No, The short line
will fit in the box and the long line will truncate. I expect that. Is there
a way to determine, within the report detail, whether the line was truncated
or not, and where? I tried comparing the source data with the value in the
control, but apparently the value in the control is the untruncated long
line, even it it won't all display. It always compares equal, even with
truncation.

Reply to this Message

Allen Browne - 13 Mar 2007 02:50 GMT

See Stephen Lebans' information here:
http://www.lebans.com/textwidth-height.htm

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> If I put a text box on a report and fill it with text which may be a short
> line or a long line, and I set the property to CanGrow=No, The short line
[quoted text clipped - 4 lines]
> untruncated long line, even it it won't all display. It always compares
> equal, even with truncation.

Reply to this Message