>Hi,
>
>We have a grid with a column displaying a N(10,2) field that we want to be able to modify. It works fine, but the grid becomes difficult to read with many such columns. To make it more readable we would like the column to display '' when value is 0.00.
>
>We have tried different ways without sucess:
>
>-Setting the column controlsource to IIF(amount > 0.00, amount, '') displays it properly, but does not allow us to modify.
>
>-Setting DynamicCurrentControl again displays it correctly, but when entering the textbox to modify, the forecolor and backcolor are set to those specified but DynamicForeColor etc.
>
>What I would like to have in some property 'blank if zero'.
>

A SWAG - you might try adding a spinner in the column, with the column's .SPARSE property set to .T. and the spinner's .FORMAT property set to "Z". I haven't tried this myself.