>>Hopefully this is a quick one for you experts out there. I have a grid that has several fields that have their color set in a complex way that I don't understand, but it works. I have a need to override the colors of certain columns based on an overdue date. I have code that works BUT it always sets makes the color either red or white and I need it to make it red if a condition is met and NOT change it from what it is if the condition is not met.
>>
>>Here is my code that changes it to Red - But also can change it to white:
>>
>>this.column4.DynamicBackColor = 'iif(duedate < DATE(),RGB(255,50,50),RGB(255,255,255))
>>
>>Here is the code that I thougth would work but doesn't:
>>
>>this.column4.DynamicBackColor = 'iif(duedate < DATE(),RGB(255,50,50),this.column4.DynamicBackColor)'
>>
>>Here is something else that gives me a variable undefined:
>>
>>IF duedate < DATE()
>> this.column4.DynamicBackColor = RGB(255,50,50)
>>ENDIF
>
>Just a SWAG (untested):
this.column4.DynamicBackColor = 'iif(duedate < DATE(),RGB(255,50,50),EVALUATE([this.column4.DynamicBackColor]))'
look for recursive eval