Decimal Problems populating a combo box

[jlindquist23]

Hello!
I'm using a combo box to populate fields in my database.
This table is linked to a larger database and is a text field.
The text field has decimal "like" values. .4, .5, 1.5, etc.

I'm using a combo box, marked as 1 below, to populate the PinDia field in my form.

When the data comes in, it truncates the vale to an integer. How do I stop this from happening?
So... the .4 comes in as a zero. 1.5 comes in as a 1.0.

The table I'm pulling it from shows all the data correctly.

[Minty]

If the picture is of your table then the fact the numbers are left aligned would indicate access thinks they are text.
So this is possibly your issue. If not try changing the decimal places on the form to 2 or 3?

[jlindquist23]

Yes!
Thank you!
I need to change the data type of the table it is coming in to.
Right now I have it as a number. I need to change that.
Thanks for your help!

[June7]

Should be Number type with FieldSize Double, not Integer.