I am using VFP 9 and I need to have the color change in the grid rows
based on the change of a column value.

What I have is one field that contains a value there will be several
records in a row with the same value. I would like all the rows with
the same value to have the same row color. Then when the value changes
so does the color.

I Have played with the dynamicbackcolor and have not been able
to make the colors change when the value changes

Heres the code I use in the grid init:


* - Set conditional color for pending reservations

This.Column1.DynamicBackColor = ;

"IIF(toolloc.tores = 'RESERVED', RGB(133,141,158), RGB(255,255,255))"

This.Column2.DynamicBackColor = ;

"IIF(toolloc.tores = 'RESERVED', RGB(133,141,158), RGB(255,255,255))"

This.Column3.DynamicBackColor = ;

"IIF(toolloc.tores = 'RESERVED', RGB(133,141,158), RGB(255,255,255))"

This.Column4.DynamicBackColor = ;

"IIF(toolloc.tores = 'RESERVED', RGB(133,141,158), RGB(255,255,255))"

This.Column5.DynamicBackColor = ;

"IIF(toolloc.tores = 'RESERVED', RGB(133,141,158), RGB(255,255,255))"

This.Column6.DynamicBackColor = ;

"IIF(toolloc.tores = 'RESERVED', RGB(133,141,158), RGB(255,255,255))"

This.Column7.DynamicBackColor = ;

"IIF(toolloc.tores = 'RESERVED', RGB(133,141,158), RGB(255,255,255))"


"Kevin R Baugh" <krbaugh1 (AT) yahoo (DOT) com> wrote

Thanks for the idea I was able to figure it out with some help from the
guys at

http://groups-beta.google.com/group/....fox.vfp.grids