It is said that what you describe will be scriptable in FileMaker 7 later
this year. At present, it is a bit more complicated (without knowing what
the scripting will look like).
You have your field Value.
Define several calculation fields:
ValueMinus = If (Value < 0, Value, "")
ValueZero = If (Value = 0, Value, "")
ValuePlus = If (Value > 0, Value, "")
Place the three fields on your layout, identical in all formatting except
color, with transparent fill. Set each to the color of your choice (e.g.,
red for ValueMinus, black for ValueZero, green for ValuePlus. Align them on
top of each other and group them for easy positioning.
This method is obviously best suited for display (the Value field need not
even be on this layout). If you really want this to be the input layout as
well, put Value (again, identically formatted) behind the other three, and
use tabbing or a Go To Field step in a script to get into it for entry.
If you didn't want the three calculation fields, you could make them glabals
and, but you would have to use scripting to set and reset each according to
in article 4ck0c.7081$RB.email@example.com, David Price at
firstname.lastname@example.org wrote on 2/29/04 6:39 AM:
> I've been away for sometime so greetings to all at the best FM group on the
> net. I've got a field containing numerical values ranging from -3 to +3 and
> a want to set the text colour according to these values - red for -3 ranging
> through to green for +3. Is there any way of achieving this. I run a script
> to sort them by the value in this field so I can attach further lines to
> this script or run a sub-script. All advice appreciated.
> Regards, David