>A question about grids and a column.
>Basically I want one column to display a green or red dot or ball. Based on the .t. .f. value of a field in a table.
>
>How would I go about creating the red or green dot/ball?
>
>How would I place that dot/ball in the first column depending on the value of .t./.f. of the field in the table?
>
>Pretty new to this stuff and can't get it to do what I want.
>
>Any help would be appreciated.
>
>Thanks,
>
>Troy
Troy,
For coloring you'd use DynamicForeColor.
And use wingdings font on that column to get the ball/dot character you want and display a character instead :
With thisform.myGrid.Columns(n)
.ControlSource = '(iif(myAlias.MyField,chr(0xA4),chr(0xA3)))'
.FontName = 'WingDings'
.DynamicForeColor = '(iif(myAlias.MyField,0x00FF00,0x0000FF))'
endwith
Cetin