cant display .001 value in Access table

[mattm1958]

Access Newbie here - I have fields formatted as general numeric, and they show 0.000, but when I put in a value like .005 the field simply shows .000. And when I put in 20.005 it shows 20.000.

 

[xenou]

Access might use a different rule for rounding (aka Bankers rounding). You should try 21.005 please ... what happens?

 

[Joe4]

What is the underlying data type ("Field Size" property) of the Table Field?
Note that if it is something like Integer or Long (Integer), it cannot hold any decimals, so will always show 0s for the decimals, no matter how many places you elect to show.
You need to choose an option that allows decimals, like Single or Double.

 

[xenou]

^ Yes Joe's seems more likely actually if you're values always display as X.000 - you could be just applying a decimal format to an integer (or long integer) data type...

 

[mattm1958]

All you fellows were onto it immediately! I'm just getting back into this 'improvement' project now ( the urgent projects always win out, don't they?). And while it was difficult to find where to change the property (pull up the table, in the far upper left change view to Design, from the list that appears, click on field in question, a box appears below, then in the lower box, change the field property titled "field size" at the bottom, to double.

THANKS. I would never have known, or found it, otherwise.

 

[Joe4]

You are welcome.

Glad we were able to help.