How to prevent field formatted for currency from rounding?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field that uses the format property set to Currency.

If I type in $346.89, the value gets rounded to $347.00.

How do I prevent this?
 
I have a field that uses the format property set to Currency.

If I type in $346.89, the value gets rounded to $347.00.

How do I prevent this?
Click to expand...

You may have set the field's Format property to Currency but what is
the field's Datatype?
If the field datatype is Number, field size Integer or Long Integer,
by definition an Integer is a whole number and cannot have a decimal
value. Either change the field's datatype to Number field size Double
or set the datatype to Currency.
 
Back
Top