decimal on forms

[Cristina]

Good day,
I need some help with a form.
I have a table with one field -Exchange rate. I have a form to input the exchange rate when the rate changes.
I have a form to input data into my Expenditure table, and a combo box to read and input the exchange rate into the Expenditure Table from the Exchange rate table.
In both tables the filed is set to
Data type = NUMBER
Field size = DOUBLE
Format = FIXED
Decimal places = 5

On both forms the combobox properties are:
Format = FIXED
Decimal places = 5

When I click on the combo box on the expenditure form, I see only one decimal, and only one decimal is captured in the table.

Would someone please tell me what I am missing. I dont know how to write codes.

Thanks

 

[ypma]

Christina, demo of you database would enable users of this forum a chance to see what is going on and hopefully come up with a solution .

Regards Ypma