>Hello there,
>
>I recently worked on a grid which contains a column with the following ControlSource:
>
>OrdDet.quantity * OrdDet.unitprice * (1-OrdDet.Discount/100)
>
>The problem I am facing is that the value displayed in the textbox of the column is something like this, "12.0000000000", too many zeros!!. Can anyone of us tell me how to make the number appear as "12.00"?
>
>I tried to SET DECIMAL TO 2, SET FIXED ON, put something in the 'Format' property of the column (and also the text box in the column), but nothing seems to work.
>
>Please help!!!!!
>
>Best Regards,
>khjuan
Set "inputmask" property to something like 99,999.99 (and "Format" property to Z if don't want to see zero values etc.)
Cetin