two decimals

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.
 
F

fredg

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top