Originally posted by MrResearch
Can anyone let me in on this secret? I have a text box which is bound to a number contol source.
However when I enter a number such as "0625874" it records it as "625874" without the leading "0" is there a fix to this maddnes?
Should I just use a text field? What are the consequences of doing such?
Access is trimming the leading zero because for all intents and purposes, 0625874 = 625874. The zero is essentially aesthetic. That said, it is easiest to simply store the number as 625874, then apply a display format of 0###### to any text box you would like to display the number in. That basically translates to "if there is no number in the first digit, display a zero instead".
I should also add:
If you're absolutely hell-bent on storing the "number" as 0625874, you could convert it to text and store it as a string.