I'm trying to get FileMaker to display calculated values in the color I picked through FileMaker's TextColor function when I display those in fields on layouts I created.

For some unclear reason, the calculated values appear in black only, and only show color when I click on them.

Is there a known workaround to this? I couldn't find information on this anywhere. Any hints will be much appreciated!

TextColor only works on text fields. Are your fields numbers or otherwise?

I'm trying to reproduce Excel's feature that can change a number's color according to a calculation result. I simply need to mark negative results in red.

There is a checkbox to set negative numbers red in the number format dialog box.

Wow, can't believe I missed this! Thanks a lot!

Queue said ... TextColor only works on text fields.

Actually JT, TextColor will work on number fields. It breaks if the number is then formatted at the field level (instead of leaving it as general format). Dates fields however will never colorize ...