Cetin
I have put the first line ie
thisform.grid1.Setall('DynamicBackColor','(thisform.GimmeColor(manifest.status))') in form init
The rest of your code I have out in a new form method called GimmeColor
I get invalid dynamicbackcolour expression
What have i done wrong?
Colin
>>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
>
>
>* Anywhere you want to set dynamic coloring - ie: form init
>thisform.myGrid.Setall('DynamicBackColor','(thisform.GimmeColor(manifest.status))')
>
>*Form custom GimmeColor
>lparameters tcValue
>do case
>case m.tcValue = 'A'
> return 0xFF0000
>case m.tcValue = 'B'
> return 0x00FF00
>case m.tcValue = 'C'
> return 0x0000FF
>otherwise
> return 0xFFFFFF
>endcase
Cetin
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing