two decimals

  • Thread starter Thread starter JIM.H.
  • Start date Start date
J

JIM.H.

Hello,
In the report detail, I am changing decimal property to 2
it does not work, how can I present all numbers with two
decimals.
Thanks,
Jim.
 
Hello,
In the report detail, I am changing decimal property to 2
it does not work, how can I present all numbers with two
decimals.
Thanks,
Jim.

1) in the control's Format property, write:
#.00

or ...

2) As control source in an unbound control:
= Format([FieldName],"#.00")

If you wish comma separated thousands (12,345.00) then use "#,###.00"
 
Back
Top