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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
If the type of the field is Long or Integer that will round the number,
change it to Double or Single
 
KenF@bsahs said:
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?
Click to expand...


Try changing Field Size to Decimal and Scale to 1.


--
 
Back
Top