>Cetin,
>
>Just one final thing, not important but would just finish this nicely.
>
>Now that I'm setting the background of certain columns depending in the values in them, the highlight of the current record row does not work for these colums. IE there set to white. I've been looking at your class and trying to work out to add to my previous line, to take into account the current record.
>
>This.ColCReq_Rings.DynamicBackColor="IIF(LEN(TRIM(STRIPS.Req_Rings))=0,IIF(RecNo(.RecordSource) == .nCurRec,RGB(255,255,255),RGB(.cCurRecForeColor),RGB(0,255,0))"
>
>Now quite right I know, how do I pass the .cCurRecForeColor into the RGB command?
>
>Regards :)
Not tested of the top of my head :
This.ColCReq_Rings.DynamicBackColor = ;
"IIF(LEN(TRIM(STRIPS.Req_Rings))=0,IIF(RecNo('"+this.RecordSource+;
"') == this.nCurRec,RGB(255,255,255),RGB("+this.cCurRecForeColor+;
")),RGB(0,255,0))"
Cetin