Hi Juan
The property you want to set is the textbox's InputMask. ie 99.99
>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
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.