>>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.
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.