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

Thanks