>>>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.
Naomi
I think I see what you mean but I'm not sure
Any chance you could give me the complete code
Thanks
Colin
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing