Hi... I'm having some trouble trying to get a grid to highlight it's disabled rows according to this concept...

If the dist_order value of a record of the Dist table is 1, then make the DisabledBackColor property be WHITE....

else

make it GREEN..

using this code below in the Form's refresh...

ThisForm.grdLocate.SETALL('DisabledBackColor', ;
"IIF(t_dist.dist_order = 1, RGB(255, 255, 255), RGB(0,255,0))")


but it just errors out, with the error...

"Data type is invalid for this property"....

(Not all of the cells of the row are disabled... just the first cell, the rest are enabled.)

Just for fun, I changed the above command to...

ThisForm.grdLocate.SETALL('DynamicBackColor', ;
"IIF(t_dist.dist_order = 1, RGB(255, 255, 255), RGB(0,255,0))")

and this works fine for the enabled cells.....

??? Any ideas?? What am I overlooking??