Number Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
1foxi said:
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.
Click to expand...


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