>
If the price field is less than 100 (for that row), I would like to display just the price field in red otherwise in black. Also, if the user modifies the price the foreground colour should change as necessary.
>>In other words, some prices may have a foreground colour of black and others - red.>
>Use this for the column's DynamicForeColor and refresh the grid when the user changes the price.
>
>IIF( MyTable.PriceField < 100, RGB( 255, 0, 0 ), RBG( 0, 0, 0 ) )
Marcia,
Tks.