Decimal on Form

[Cristina]

Good day ,
I need some help with a form.
Two tables in my database...budget and expenditure have a common field ITEM CODE, set to data type TEXT
I have a form to input expenditure and to read the Item Code from the Budget to input into table Expenditure.
Whenever the Item Code ends w ith a zero eg 4.1.0, input from the form leaves off the zero, i have codes eg 1.2.1.1 1.2.2 so it in not a specific number of decimals.
so in case of 4.1.0 input is 4.1
Is there some way to stop this from happening.


Thanks

 

[KenHigg]

How is the code getting into the second table?

 

[Cristina]

I keyed the data into the budget table. When I am entering expenditure, I use a form, and use a combo box to select the item code and enter the item code to charge the expenditure to.
If I key directly in the expenditure table, it holds the 4.1.0, but using the form, it only shows up as 4.1, even though it is reading from the budget table that has it as 4.1.0
Thanks

 

[Gasman]

What is the Decimal Places property of the text box set to.?

I tried it on a test form with a new text field and it works fine. My property is set to Auto.

 

[Cristina]

My decimal is set to auto. When I click on the drop down arrow for Format on the form properties no options are available. strange, it does not show up in the combo box drop down arrow , it is not reading correctly from the source as 4.1.0, it only shows up as 4.1. I made a new combo box and it still does not work.
Thanks