Decimal on Form

vendredi 3 avril 2015

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

Decimal on Form

0 commentaires:

Enregistrer un commentaire

Labels