decimal on forms

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

decimal on forms