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