No, that didnt do the trick either. I dont think the refresh event will be called for each cell ...
The control source is a cursor.
>Try this: ColumnX.refresh:
>
this.value=iif(yourfield%1#0,transform(yourfield,'999.999'),transform(yourfield,'999.999.99')
>Is the controlsource a cursor or a table?
>
>
>>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.