Rounding Numbers

[Guest]

I have a data field, data type number, field size 'Single'.
The user types the numbers into a text box on a continuous form but
unfortunately some values are rounding. If I type in 0.145, the value
displayed on the form changes to 0.15 when I tab off it, similary 0.214
changes to 0.21. How can I prevent this from rounding and displaying the
exact amount the user types into the text box?

 

[Allen Browne]

Sounds like a problem with the formatting.

Open the table in design view, and select this field.
In the lower pane, remove anything from the Format property.

Then open your form in design view, and select this text box.
Remove anything from the Format property.

Of course, there are only about 7 significant digits in a Single, but your
example shows only 3 so I assume the issue is with formatting.

 

[Guest]

Thanks Allen - I checked that but the format fields were already blank. I
also checked the table to see what value is being saved to the table, and the
correct value is being saved (.214, .145), but it is still displaying a
rounded figure. Any other ideas?

 

[Allen Browne]

I'm not seeing that, Eileen.

With Format blank and Decimal Places set to Auto, when I open the table I
see the numbers exactly as entered.

I wonder what's different?

 

[Guest]

On the form I know that you have checked the format, but did you check the
'Dedimal Place' area? I believe that if you set it to Auto you should see
exactly what you type in. Sometimes Access defaults to 2 decimal places.