Lookup field is ignoring a value

[Guest]

I have a look up field that includes the numbers 0, 0.5, 1, 2, 3, 4...10.
The pick-list appears, but when I try to select the 0.5 it won't allow that
value to be used in the field. I also have the "Decimal Places" set to
"Auto."

Am I missing some other setting that will allow the entire pick-list to be
used and not just the whole numbers?

 

[Albert D. Kallal]

I have a look up field that includes the numbers 0, 0.5, 1, 2, 3, 4...10.
The pick-list appears, but when I try to select the 0.5 it won't allow
that
value to be used in the field. I also have the "Decimal Places" set to
"Auto."

Am I missing some other setting that will allow the entire pick-list to be
used and not just the whole numbers?

You should probably check as to what the data type is for the field. if the
data type as integer or long integer, then you'll only be able to store
whole numbers.

I would check the underlying field in the table design view...

A good choice for this would be actually to use the currency data type, as
then it will not suffer rounding errors. It really depends on what you're
using this field for, but do check the underlying data type via the table
desing view........that sounds like your problem here.