Klas,
Have you considered adding a second textbox to the grid column? Text1 is set to the field, and text2 would be set to the 'IIF(amount>0.00, amount, ' ') function. Use the CurrentControl function to switch to Text1 for editing, text2 for all other display purposes (use When()and LostFocus() ).
HTH
Barbara
>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'.
>
>
>Klas Nygren