>>I had an IIF statement in the dynamicBackcolor property of a grid that wasn't working correctly. So I started to try and figure out what was wrong and then realized I can't get the DynamicBackColor to work at all for me. I must be doing something wrong...I have ="rgb(255,0,0)". I've tried it with and without the quotes.
>
>DynamicBackColor usually includes IIF function, e.g.:
>**** Grid.Init event
>cLine1="IIF(recno="+this.tag+",16711680,8421376)"
>this.SetAll("DynamicBackColor",cLine1,"Column")

Hi Edward,

I put the following line in the grid's init event:

cLine1="IIF(schedule.sch_absent = .t., rgb(255,0,0), rgb(0,255,0))"
this.SetAll("DynamicBackColor",cLine1,"Column4")

But the column's BackColor is still white do you see anything else that I am doing wrong?

Paul