Hee Lim

In code:

Set decimals to 2
Set Fixed on

In your report select the QTY field and double-click to get properties.
Click on the Format button or type your format in the text box, e.g. ZZZ,ZZ9.99

If the field is on a form, set its InputMask property.

HTH

Terry


>my report form has a QTY control
>if my QTY is an integer it will display as 999,999
>if my qty is having 1 decimal place it will display as 999,999.9
>2 decimal places it will display as 999,999.99
>3 decimal places it will display as 999,999.999
>4 decimal places it will display as 999,999.9999
>
>for PRICE control I want to set it to 2 decimal places
>but the format will auto change if the decimal places is increasing....