Changing Font Color By Calc Result

[nightdesigns]

Is it possible to have a font color change by what a result of a calc is? Or is there a better way to do this? If "X" field is empty, I'd like a font on a tab to be grey, of if "X" is not empty, to make the font black.

Thanks.

[slstrother]

You will need two calc fields, I will call them Color1 and Color2. Make them exactly the same size and transparent. Format the text in Color1 to be gray and the text in Color2 to be black. Place one on top of the other.

Color1=If(IsEmpty(Xfield),"Your Tab Text","")

Color2=If(not Is Empty(Xfield),"Your Tab Text","")

[mborgens]

Another solution that I like to use is a second global, repeating, container field that is place behind a transparent text field and change it's color based on the desired calc result. This way I can setup a multiple colors/images based on results (plus, this is what I think is a valid use of repeating fields;). mb