Yes
>Hi Jos,
>
>is the column read only?
>
>>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
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.