I know this question has been asked and answered a million times before but I can't find any reference to it in the search files and my brain isn't working real good today......So I thought I would ask again.

[color:red]How do you conditionally format the text color of a field based upon the value of another field?

I have two fields: Customer & Status.

If the status is "HOT" the text color for customer name should be [color:red]RED.

The field is populated via "value from last visited record" and has

a calculation set to: [color:blue]Case ( status = "hot";TextColor ( Customer; RGB ( 255 ; 0 ; 0 ) ) )

The only thing that happens when status is set to "HOT" is that the customer name disappears.

Any ideas how to make this happen?

Thanks,

Jarvis

you at least need one more parameter to your case statement. As it is, the customer name will have nothing if the status is NOT hot. try:

case(

status = "hot";

textcolor(customer; RGB (255;0;0)0;

textcolor(customer; RGB (0;0;0))

)

Thanks Slobey!

I just noticed this! Uh yeahh, sometimes I'm a bit slow ...

Jarvis, since you have vs. 9, I'm sure you now realize you can use conditional format on that Customer field instead of creating a needless calculation. But just in case others read this thread and wonder:

Attach a conditional format to the Customer field with:

theTable::Status = "Hot"

Set the text color to red within the conditional format calculation box. No calcs needed! This still makes me smile every darned day when I DON'T create calculations to handle these types of issues.