Is the cursor the result of a SQL select statement?

Select *,Cast(Iif(yourfield%1#0,yourfield,Int(yourfield))as c(10)) as showvalue ...

>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