Rounding of Numbers

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

Guest

Hi

I have created some number fields on my form.
Formatting
Number, Standard, 2 decimal places

When a user enters a number e.g. 1.5 into the field it changes to 2.0. Is
there a way to stop this so that the numbers can remain as they are entered.

Thanks
 
Open the table in design view.
Select the problem field.
In the lower pane of table design, change the Field Size to:
Double

The integer types store whole numbers only.
 
Back
Top