BTW, here is the same question Another Grid's Column's DynamicInputMask Question Thread #1078714 Message #1078714 (though no answer).

>>>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?
>>
>>One closing bracket for the IIF() function.
>>

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

>
>yes I fixed that but it only takes effect when I click on the cell, and even then it seems to apply / not apply sometimes ...
>
>I cannot turn Sparse true since I then lose other dynamic formatting.