>>>Hi friends:
>>>
>>>A grid showing a few records.
>>>
>>>Most of them (in fact every less one) have an integer data. (code, name and stock are the columns) as showing 3 decimals is not very nice I thought I could use dynamicinputmask for managing this.
>>>
>>>Is there any not integer value? inputmask is 9999.999, else 9999
>>>
>>>No matter.
>>>
>>>Apparently as data has 3 decimals (1.000 for example) column shows decimals anyway
>>>
>>>Has column.dynamicinputmask property any secret I don't know?
>>>
>>>Thank you.
>>>
>>> Héctor
>>
>>How do you know what is integer and what is not?
>>Because 1.000 and 1 are stored the same way in the table.
>
>Hi Boris
>
>I scan and compare int(num)=num?
>
>And it works. I put a message, sometimes yes, sometimes not.
>
>No problem with logic.
>
>Thank you.

Try:

thisform.Grid1.Column.DynamicInputMask = "IIF(TheField%1=0,'9999','9999.999')"

Not tested.