Thanks Marcia. That was the problem. I was able to get it to work using
the function below. As you can see I had to change this.value to a function call where I passed the field name like you suggested.

thisform.grid1.SetAll("DynamicForeColor", "f_color(sex)", "Column")

the only problem with the above statement is that it changes the color for every column. how would I change that syntax if I just wanted to change Column1?

N.


>Hi Nancy.
>
>IIF(THIS.VALUE = 'Female', rgb(255,0,0), rgb(0,0,0) )
>
>PMFJI, but you do not want This.Value. Use the alias.field for the data in the field in the grid's RecordSOurce and this will work as advertised.