Formatting the numeric values to two decimal places in Access reports 1

[ppullag1]

Hi there,

I am trying to format my calculated fields in an Access Report to have only two decimal places. I tried setting the property "decimal places =2" which did not work. Then, I tried setting "Format = Fixed ", "Decimal places = 2" for those fields in the reports which also did not work.

Any help is appreciated. Thanks in Advance.

 

[earthandfire]

Try

=Format(CalculationFormula, "#,##0.00")

as the controlsource

Hope this helps

 

[ppullag1]

Thanks Earthandfire for the reply but it did not work. The control source I used is a calculated field in a query and I just used the field from the query as the control source, if that makes any difference. I tried the format command but it did not work.

 

[earthandfire]

Try either:

Assume fieldname form query is CalcField1 then as the control source use:

=Format(CalcField1, "#,##0.00")

or:

Assuming a simple calculation in the query of:

CalcField1:Format((Fld1 * Fld2), "#,##0.0")

placing the format function as above in the query field