Textbox Truncated

[Keith]

Is there a way to force a textbox on a report to indicate that it has
truncated the data it is supposed to be displaying? I know this works with
date fields, where it shows # when the textbox isn't wide enough. Is there
something similar for text data?

I have seen this issue addressed in regards to Textboxes with a memo field
as the control source, but not with a text field.

Thanks,

Keith

 

[Marshall Barton]

Is there a way to force a textbox on a report to indicate that it has
truncated the data it is supposed to be displaying? I know this works with
date fields, where it shows # when the textbox isn't wide enough. Is there
something similar for text data?

I have seen this issue addressed in regards to Textboxes with a memo field
as the control source, but not with a text field.

A text box or any code in an event procedure does not do
anything different for a memo field or a text field, so
whatever works for one will work for the other.

I'd be interested in seeing what you are using for memo
fields. In the meantime I will try to imagine something
that can do what you asked (probably using the
TextHeightWidth code at www.lebans.com)