I have a number field. I'm trying to use a script to change the field font to Red and Bold if the value is under 220. Of course this wouldn't affect the actual data in the field, just the appearence of it. I know how to evaluate the value but not how to change the font color and style of the field. How would I do this?

Thanks!

Corey Martin

The easiest way to do this is to create a couple of calculation fields that are based on your current number field.

You place one on top of the other and have the calculation show or be blank based on your number field.

The attach file is a quick demo of this.

HTH

Lee

ChangeTextColor.fp5.zip

Thanks for your reply and example. It does work, but there is one problem. Users have to be able to change the number. If I stacked two calculation fields on top of eachother to provide the effect of changing colors based on the number value, the user wouldn't be able to change either field. Is there a way around this?

Thanks,

Corey Martin

Just change the fill for the field "Red" to White, and then stack all three (i.e. align center /center)

This will make it do what you want.

Lee