Access rounds up/down currency column

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!
 
V

Van T. Dinh

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.
 

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

Similar Threads

Rounding in a Currency Field 4
Round up/down duration 0
Rounding dollar amounts to the 9 cents 0
Currency Field 5
Currency and Rounding 0
Stop Rounding Currency 20
Inconsistent rounding on currency fields 3
Rounding Up or Down 1

Top