General information
Category:
Forms & Form designer
Title:
How to NOT change DynamicBackColor
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
Any help is appreciated.
Thanks,
Randy
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only