I have searched the threads and tried solutions but none of them have worked thus far, this is why I am asking the question again.
I have a combobox on a form that I use to select a decimal number (.5, 1.0, 1.5, 2.0, 2.5, etc.) sourced from a query, the query source is a table field containing the decimal numbers.
On the source table the field properties are:
Data type = NUMBER
Field size = DOUBLE
Format = FIXED
Decimal places = 1
On the form the combobox properties are:
Format = FIXED
Decimal places = 1
The decimals show up fine when I click on the drop down arrow on the combobox. However, when I select "1.5" as an example, it inputs "1.0" into the form. As I stated above I have tried all of the suggestions I could find regarding this problem but have still come up short...can anybody help with this?
I have a combobox on a form that I use to select a decimal number (.5, 1.0, 1.5, 2.0, 2.5, etc.) sourced from a query, the query source is a table field containing the decimal numbers.
On the source table the field properties are:
Data type = NUMBER
Field size = DOUBLE
Format = FIXED
Decimal places = 1
On the form the combobox properties are:
Format = FIXED
Decimal places = 1
The decimals show up fine when I click on the drop down arrow on the combobox. However, when I select "1.5" as an example, it inputs "1.0" into the form. As I stated above I have tried all of the suggestions I could find regarding this problem but have still come up short...can anybody help with this?
