Hi Tore,

I am trying to get this to work. I have the following set in the properties window DynamicInputMask for the column:

" IIF(myField%1=0),'999,999','999,999.99' "

But it does not seem to have any effect. What am I missing?

Thanks



>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