Rounding of Numbers

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rounding problems 11
Text boxes rounding entries 3
Unwanted Numbers Rounding 6
Rounding Numbers 4
Numbers in Access form 1
Concatonate numbers 8
Decimal places in forms 2
Numbers are automatically rounding up in Tables, Forms, etc. 3

Top