Change appearance of entered numbers
Posted on 2014-11-22
On a form I have two fields. The first field is named txtSIZE_CURRENT.
If the user enters, for example, 0.109 in that field I want the 2nd field named txtPartNsize to read 1090
(always 4 numbers)
The following is close but I can't get rid of the period. It is currently reading .1090
Me.txtPartNsize = Format([txtSIZE_CURRENT], Left(".", [txtDecimals]) & String([txtDecimals], "0"))