>>>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?
>>
>>

>>*** Init event of the Form
>>
>>thisform.GridObject.SetAll("DynamicForeColor","thisform.SetGridColor()","Column")
>>
>>
>>*** Add a new method in the form called SetGridColor
>>*** In it:
>>lnRetColor = RGB(0,0,0) && Black
>>IF UPPER(ALLTRIM(GridTable.ServiceColumn)) == "STANDARD"           OR;
>>   UPPER(ALLTRIM(GridTable.ServiceColumn)) == "ECONOMY SERVICE"    OR;
>>   UPPER(ALLTRIM(GridTable.ServiceColumn)) == "STANDARD (EXPRESS)" OR;
>>   UPPER(ALLTRIM(GridTable.ServiceColumn)) == "ECONOMY"
>>   lnRetColor = RGB(255,0,0) && Red
>>ENDIF
>>
>>RETURN m.lnRetColor
>>

>>I made it as a method, because if tomorrow you (your client) decide to have different colors for different Services to be much easier :-)
>
>Boris
>
>I get unknown member gridobject when the form loads
>
>Colin

Colin,

The grid does not exist when the form loads. Do it in the form's init or better the grid's init