Decimal Places

[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

 

[Keith Wilby]

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

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