Decimals changing to zeros

[bhrosey]

I have a table that I need to enter values into but for some reason when I enter a decimal (ex: .015), it automatically changes to 0. I have the Data Type set as Number, Field Size as Long Integer and Decimal Places to 3. I have another field set the same way and it works fine. I'm confused.

[June7]

I am also confused.

Integer types cannot have decimals.

The Format and DecimalPlaces properties do not alter that caveat. Those properties do not influence how data is saved, only how it is displayed.

Change to Double or Decimal.

[bhrosey]

Thanks...working fine now.