Peter,
SETALL works like a global replace. In this case it changes DynamicBackColor for all collums in the grid. After that you're free to modify them further any way you want.
>Thanks, that worked. Just wasn't sure about the Setall vs the columns call.
>
>Pete
>
>>>I have a routine for a grid that highlights the a particular column entirely with one color. It also highlights the current row. The problem is, the row highlight "goes under" the column highlight. I need to reverse that and because of the IIF in the following lines, I can't. I need help figuring out how to change these lines.
>>>
>>>
>>>curRowRec=recno()
>>>this.SetAll("DynamicBackColor","IIF(recno()=curRowRec,RGB(0,128,255),RGB(255,255,255))","Column")
>>>thisform.grid1.columns(tagno()+1).DynamicBackColor="RGB(0,255,0)"
>>>
>>>Thanks
>>Add IIF to the current collumn DynamicBackColor also
thisform.grid1.columns(tagno()+1).DynamicBackColor= ;
>> "IIF(recno()=curRowRec,RGB(0,128,255),RGB(0,255,0))"
>>
I would also suggest that you make curRowRec a property of your grid base class or form. Otherwise it could get out of scope.
--sb--