>I have a grid populated with a cursor, and based on the value of the column control I want to change the forecolor of the column. For instance, if the value in row1 column1 is a negative integer, I want to show it in red and if row2 column1 is positive, show it black. I've played around with the dynamicforecolor, but no success. I end up changing all rows red or black regardless of the values. Is what I'm trying to do posible?
>
>Thanks!
>
>John :)

Try to put this on INIT or Activate Event of the form:

Select mytable

per Column:

Thisform.Grid1.Column1.DynamicForecolor="IIF(mytable.val1<0,RGB(255,0,0),RB(0,0,255))"

or

per Row:

Thisform.Grid1.SetAll("DynamicForecolor","IIF(mytable.val1<0,RGB(255,0,0),RGB(0,0,255))","Column")