Decimal Places

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
 
K

Keith Wilby

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
 
Top