Is there a way to half the text inside the field display "Condense" if it does not fit into the field? Now if the field is out of boundary it displays a "?" instead it should condense the field. Maybe this works with conditional formating?

Thanks

That field isn't a text field !

Sure you have setted it as a number.

That field isn't a text field !

Sure you have setted it as a number.

Maybe I did not explain to well. Is it possible if a fields contend is larger than the fields it automatically displays its contend in "Condensed" form?

You could try using the Conditional Formatting with a calculation such as

Length ( ProtectData::Data ) ≥ 15

and then have it format the field using the Text options.

I used 15 in the formula as a for-instance. What you would need to do is to change the font in the field to a Mono Type, such as Monaco, and then count the number of characters it takes before you would want to invoke your condense text condition.

HTH

Lee

Modified my calculation.

Edited July 13, 200817 yr by Guest

You could try using the Conditional Formatting with a calculation such as

Length ( ProtectData::Data ) ≥ 15

and then have it format the field using the Text options.

I used 15 in the formula as a for-instance. What you would need to do is to change the font in the field to a Mono Type, such as Monaco, and then count the number of characters it takes before you would want to invoke your condense text condition.

HTH

Lee

Modified my calculation.

Hmm I dont know whats going on but It displays the Condense all the time no matter what length, maybe it has to do that it is a number field with "fixed number of decimal" and "Do not display zero". Does that cause a problem?

Did you try it with the new calculation?

Conditional Formatting is for Text only. If you said number somewhere in your posts, I missed it.

This begs the question, Why would you need to do this with numbers?

Lee

maybe it has to do that it is a number field with "fixed number of decimal"

That's quite possible. If you're using Length ( field ) > 10 as your condition, it will count ALL decimal digits, not just the ones that are being displayed. Try something like:

Length ( Int ( Round ( field ; 2 ) ) ) > 8

BTW, I don't think condensing will allow you to squeeze in more than one additional digit.