ComboBox Rounding Numeric Values

[acannon]

Greetings, I have a form containing a combobox as a picklist for one of its values. The rowsource for the picklist is a table containing only the one field. The field is formatted as numeric, decimal, 2 decimal places, and the data in it was entered manually as 2 decimal places even where the value was a whole # like 5.00. The table receiving the data from the picklist via a query and form is formatted the same as the rowsource table. Some of the rowsource values are fractional, such as 7.50, but when that value is picked from the picklist it is displayed and entered into the table as 8.00. I have tried everything I can think of in the way of numeric formats, decimal precision, etc, and cannot get the result of the picklist to not be rounded. In every instance the value is rounded up to the next whole # for any fractional value in the rowsource table.

How do I get the value entered from the picklist to stop rounding? Any help will be greatly appreciated.

[pbaldy]

What is the data type and field size of the field in the destination table?

[acannon]

Thanks, pbaldy! You jogged my memory and got me to look at the underlying table since the form was based on a multi-table query. The underlying table format was the problem, and is now fixed.

Thanks!!!

[pbaldy]

Happy to help!