Rounding of Numbers

M

microsoft

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
 
A

Allen Browne

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.
 
Top