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....
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.