>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]))'
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up