>I want to be able to change the row color to red in the grid...
> if alltrim(thisform.grid1.column1.text1.value)<>"" and thisform.grid1.column2.combo1.value ="". then switch=.t.
>
>WITH THISFORM.GRID1
> .SETALL("DYNAMICforeCOLOR","IIF(switch,RGB(255,255,255),RGB(0,0,0))","column")
> .SETALL("DYNAMICbackCOLOR","IIF(switch,RGB(255,0,0),RGB(255,255,255))","column")
>ENDW
>THISFORM.GRID1.REFRESH
>
> I am not sure where to put the code and how to make it work. I turned a row red if a check box was true, but the same logic isn't working. Also, if there is a better way to do this, I would want to know.
>
>TIA,
>Jim
Hi Jim,

Are your column1 and column2 linked to fields ?
If yes use the fields to build your dynamic color condition.
Your switch variable is not refreshed by the grid.
Otherwise you need to use a macro substitution in the DynamicBackColor condition ( or calling a function or method ).

Marcel