In Access field 0.5 becomes 0 and 1.5 becomes 2

[Guest]

I have a field looking up a list which includes 0.5, 1.00 and 1.50. When
0.50 is selected, only 0 appears and when 1.50 is selected it shows as 2. I
want to be able to enter from a look-up list or table numbers to 2 decimal
places (I have already set the decimal places formats to two places)

 

[Paul Overway]

What data type is the field? It sounds like you have it set to integer or
long. It needs to be currency, single, or double.

 

[Guest]

Thanks for the response. I originally set it to currency, but you can't use
look-up from a currency field. However, I've changed the data type to
Number, Field Size to Double and Format to Currency and it works. Many
thanks!
Access Enthusiast