Rounding up sometimes not others, in form but not table!

[thirtydash9]

Hi,
I'm stumped.
I have a table with one of the fields formatted 'double'.

There is no problem with inputting numbers in this field. I can input decimals and it doesn't round them up.

There is a form based on this table. When I input numbers into this form in the 'double' field, it will round the number up if there are two digits to the LEFT of the decimal point, but not if there is only one. For instance, it will accept 8.75, but it turns 18.75 into 18.8!

I have looked at the field properties on the form and the decimal places property is set to 2.

I don't understand this and have tried to find the answer in existing posts but no luck.

Any ideas???
Thanks in advance.

 

[JediBMC]

I just tried this, and I can't seem to replicate any circumstance where the double is rounded either up or down. The only circumstance that could mimic this is if the width of the form field is too narrow to fit 5 characters and scrolls the last number off to the right.

-Brian-
I'm not an actor, but I play one on TV.

 

[thirtydash9]

Thanks, JediBMC.

I did try changing the column width (it's datasheet view btw) and inputting a large whole number.

Since it works in the table, it should have something to do with the form field properties...

By the way, it did work before - so maybe the db is corrupt. I will create a new one and import; that may fix it.

Thanks for trying!