> > Dear Experts

> >

> > Table1 has only one numeric field as n(8,3) and data in this field is as

> >

> > 1.000

> > 1.200

> > 5.658

> > 157.658

> > 5.000

> > 148.657

> > 9.000

> > 5.658

> >

> > I want to display this column in grid as

> >

> > 1

> > 1.2

> > 5.658

> > 157.658

> > 5

> > 148.657

> > 9

> > 5.658

> >

> > What dynamic format should I use?

> > Or is there any other method?

> > (Single digit if there is no decimal)

> >

> > Please help

>

>

> This is simple solution using DynamicInputMask:

>

>

> thisform.Grid1.Column1.DynamicInputMask = ;
> [IIF((ctable.num%1)>0,] + ;
> ['9,999.'+REPLICATE('9',LEN(LTRIM(RTRIM(STR((ctable.num%1)*1000),0,'0')))),'9,999')]
>
> *!* OR
>
> thisform.Grid1.Column1.DynamicInputMask = ;
> [IIF((ctable.num%1)>0,] + ;
> ['9,999.'+REPLICATE('9',LEN(LTRIM(RTRIM(STR((ctable.num%1),8,3),0,'0')))-2),'9,999')]
>
>

>

>

> If your grid is editable then:

>

>

> *!* Grid1.Column1.Text1.GotFocus
> this.InputMask = [9,999.999]
>

>

>

> Regards,

> Onytoo

Thanks Sir,

Following procedure works fine for me

thisform.Grid1.Column3.DynamicInputMask = ;
[IIF((closing.open_qty%1)>0,] + ;
['9,999.'+REPLICATE('9',LEN(LTRIM(RTRIM(STR((closing.open_qty%1),8,3),0,'0')))-2),'9,999')]

But.......

How to hide 0, zero value?