Field size set to double: 0.5 is input but the table says 2

[funwithaccess]

I have a form that utilizes a combo box with 2 options: 0 & 0.5. If I select 0.5 on the combo box the field in the table records it as 2. Why doesn't it reflect as 0.5? And how do I fix it?

This is the general info that I have for the field properties:
Field Size - Double
Decimal Places - 1
Default Value - 0

 

[pbaldy]

What's the bound column of the combo and the row source?

 

[funwithaccess]

Once again, you nailed it! It was bound to the ID field. I set it to 2 and it works perfectly now! Thanks again, Paul!

 

[pbaldy]

Happy to help!