Is there any way to indicate if a text field has more text in it than is visible on the layout? e.g. build a little script field that can tell if the field has hidden characters and show an indicator.

Thanks in advanced for any ideas or hints.

Anatole

if you're doing this on a single layout, you could count the number of characters that fit in the field you are showing. You can create a calculation that is a number as follows:

Length( theField ) > 50 //where 50 is the number of characters that fit in the field

Then put the new calculation field on teh layout. Right click and select "Number Format". Select "Format as Boolean" and leave "Show zeros as" blank and put whatever 'flag' you want in the "Show non-zero's as", such as a • or * or !... etc etc.

IF you're doing it across multiple layouts, it starts to get harder if the fields are different widths....

OK - thanks for that. I just wondered if there was any feedback from the layout that a field is overflowing, but I guess not.

Thanks for your help

how about changing the background if the length is over number of characters.

Check the Auto Enter calculation, and be sure to deselect the option about replacing values.

HTH

Lee

Terrible_Toll_.fp7.zip

Hi

you can try this, too.

( If there is "hidden" text into the field, then a red question mark will appear on the left side of the field )

P.S.: the text can't contain more than 8 digits

HiddenText.zip

I missed what you did with that calculation, Daniele.

Otherwise, what about someone hitting the return, not overrunning X-amount of characters? Is there a way to flag that? I just ran into this. We have three lines available for text, and quite often they use the return or enter key to make it 4 or 5 lines.

Hi

that trick works only if the available line is only one and you want only to know if there is "hidden" text into the field.

IOW that does not prevent from adding as many lines as someone wants.

BTW there are other ways to obtain what you wish...for example a validation of yourField by calculation like this:

ValueCount ( yourField ) ≤ 3 and Length ( yourField ) ≤ 100

Thanks for that Lee - that's a really cool idea and it was very good of you to send me an example too.

Much appreciated - as are all the other replies too.

Anatole