Hi,

I'm trying to find out if there is a way to know hen the text entered to a field exceeds its boundaries.

I'm not talking about the number of characters but the actual (pixel?) size of the text.

For example If my field is 160 x 30 pixels (which is about 2 rows), and the text from the first row continues on the second row - how can I detect that?

The field is actually displaying two rows, while it is actually one row and one value...

To the curious ones:

I'm doing this so I can display to the user that there is more data in the field then what they see

...and no..we cannot use the vertical scroll bar

tnx

Xtrim

AFAIK you can only estimate, and it will never be 100% reliable. Do you want to show the user the text that's not visible? If so, try setting the tooltip as Self .

I'm trying to find out if there is a way to know hen the text entered to a field exceeds its boundaries.

try this one...

FieldHeight.zip

Very cool!

It's weird, though: I tried to use a conditionally formatted text object instead of a triggered script + field, and the same formula does nothing. The data viewer shows the height as the height of the field box on the layout, regardless of the amount of text in it.

That's actually what I would have expected. But aha, I see now that when I click in the field and refresh the data viewer, it does use the height of the field contents. So conditional formatting isn't going to work, we have to store the result while the field is active, as you've done in your example.

Again, nice job, thanks for sharing.

great trick

tnx