Number Field

[1foxi]

Hi,

I have a number field in my database and every time i type in a number say =
21.53 it keeps rounding it up and I dont want it to do that.
How do I turn this off?

Thanks a lot.

 

[Brendan Reynolds]

Hi,

I have a number field in my database and every time i type in a number say
=
21.53 it keeps rounding it up and I dont want it to do that.
How do I turn this off?

Thanks a lot.

Open the table in design view, select that field, and look at the "Field
Size" property down near the bottom left corner of the table design window.
It probably says "Long Integer". You need to use Single, Double or Decimal
to store a decimal part in the field. Alternatively, if the field will be
used to store currency amounts, you can change the Data Type from "Number"
to "Currency" in the upper part of the window.