John
Thanks for the answer
Excuse my ignorance but how do I add a method to a grid?
>>I have tried multiple colors in a grid before but so far have not cracked it even with help from the experts
>>
>>Let me try again
>>
>>I have a table called manifest which has a field called status
>>
>>If status is A I want to color the row blue
>>If B the row will be red
>>If C the row will be green
>>
>>How do I do it?
>>
>>A real layman's explanation would be greatly appreciated
>>
>>Thanks
>>
>>Colin Northway
>
>
>Colin,
>I'm not sure if this is the most efficent way but we create a new method on the form (or grid) with a case statement:
>
>METHOD StatColor
>
>do case
> case status = 'A'
> return rgb(whatever color)
> case status = 'B'
> return rgb(whatever color)
> case status = 'B'
> return rgb(whatever color)
>endcase
>
>Then, in each column of the grid in the DynamicBackColor we put:
>
>
>Thisform.StatColor()
>
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing