Decimal Places

  • Thread starter Thread starter Fie
  • Start date Start date
F

Fie

Hi,

Am trying to allow users to enter in the weight of various products,
and when i enter in 123.789 access converts it to 124.00 how can i
prevent this from happening?


Fiona
 
Fie said:
Hi,

Am trying to allow users to enter in the weight of various products,
and when i enter in 123.789 access converts it to 124.00 how can i
prevent this from happening?


Fiona
Click to expand...

You need to change the field properties at table level to allow decimals.
In table design mode, make sure the field is of "number" data type, put your
cursor in the "Field Size" property and press F1 - this will show you the
different number types and their usage.

HTH - Keith.
www.keithwilby.com
 
Back
Top