Conditonally formating text color

[Jarvis]

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

[Slobey]

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))

)

[Jarvis]

Thanks Slobey!

[LaRetta]

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.