Stop round number Access 2016

Question

I can't stop MS Access 2016 rounding my decimal places to the nearest whole number. I thought the fix was simple - go to the field property ribbon and set the field data type to Number, the format to Standard and use the toggle button to the desired number of decimals. Even when I tell it 3 decimal places and enter 0.4 or 0.5 it still rounds it up or down. I can't stop it from doing it.

Answer 1

Forgive me, I don't understand. The Field Size requires a number from 1 to 255, not Double or Single. And the Field Size only becomes available if the Data Type is Short or Long Text format.

That is not the case.  A column of Number data type has a Field Size property which has possible values of Byte, Integer, Long Integer, Single, Double, ReplicationID and Decimal.  This should be set in 'Field Properties' in table design view.

Answer 2

A number data type is by default a long integer number, hence the rounding in your case.  The Format property has no bearing on the data type, it merely governs how the number is presented.  You should set the Size property of the column to either Double or Single, depending on the degree of precision you need.

Answer 3

Forgive me, I don't understand. The Field Size requires a number from 1 to 255, not Double or Single. And the Field Size only becomes available if the Data Type is Short or Long Text format.