>>My grid is driven by a table called collections
>>
>>If the service column of any record contains any one of the following I want that row to be black, otherwise red
>>
>>STANDARD
>>ECONOMY SERVICE
>>STANDARD (EXPRESS)
>>ECONOMY
>>
>>and where do I put the relevant code?
>
>Sorry I want the forecolor only to change
You can put condition for DynamicForeColor in grid's Init, e.g.
thisform.myGrid.SetAll('DynamicForeColor', 'iif(inlist(Service,"STANDARD","..etc."), rgb(...), rgb(...))','Column')
You can also create condition separately using TEXT ENDTEXT, e.g.
text to lcCondition noshow
IIF(INLIST(Service, 'STANDARD', ..),rbg(..), rgb(..))
ENDTEXT
and use lcCondition inside the SetAll method.
If it's not broken, fix it until it is.
My Blog