Access rounds up/down currency column

  • Thread starter Thread starter kath
  • Start date Start date
K

kath

I have a column in Access which is defined as a currency
column displaying pounds.

I have set it to show 2 decimal place.

As soon as i put in something that's not a whole number it
rounds it up or down. So 15.99 become 16.00 automatically.

How do you stop this happening??

thanks in advance for any help!
 
You might have set the Format to "Currency" but the Data Type is still Long
or Integer. In the Design View of the Table, just to the right of the Field
Name column is the Data Type column. Make sure you have "Currency" as the
Data Type.
 
Back
Top