>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")
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."