Do not allow a number to round up or down in Access

[Guest]

I'm a beginner with Access. I have created a table. In Table Design
View.....Data Type =number, format=standard, decimal places=1. I will be
adding several entries, hence the choice of number as data type. On the
form, the entry is rounded, no decimal places. All field controls in Form
Design View are the same as in the Table Design View. I want 18.5 to be
displayed as 18.5, 7.3 to be 7.3, etc., etc. With correct summation for the
answer. Can this rounding be stopped?

 

[Guest]

If the type of the field is Long or Integer that will round the number,
change it to Double or Single

 

[Michael J. Strickland]

I'm a beginner with Access. I have created a table. In Table Design
View.....Data Type =number, format=standard, decimal places=1. I will be
adding several entries, hence the choice of number as data type. On the
form, the entry is rounded, no decimal places. All field controls in Form
Design View are the same as in the Table Design View. I want 18.5 to be
displayed as 18.5, 7.3 to be 7.3, etc., etc. With correct summation for
the
answer. Can this rounding be stopped?

Try changing Field Size to Decimal and Scale to 1.


--