Tore,
Sorry I had a syntax error - it should be as below but still does not work:
=IIF( COL_01%1= 0, '999,999','999,999.99' )
>No, but you can probably the column's DynamicInputMask property, something like
>thisform.Grid1.Column3.DynamicInputMask = "IIF(yourfield%1#0),'999,999','999,999.99"
>
>>Hi All,
>>
>>Is there a format mask I can use in a grid that will hide the decimal portion of numerics if they are all zero?
>>
>>Thanks
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.
