I am having trouble keeping leading zeros in a form field. Access 2007 automatically truncates the zeros. How do I resolve this issue?
I am having trouble keeping leading zeros in a form field. Access 2007 automatically truncates the zeros. How do I resolve this issue?
This is marked as solved; is it? If so, posting your solution could help others in the future. If not, it's probably a numeric field, which will not hold leading zeros. You can format it for user viewing with the Format() function.
That's exactly it. All I had to do was go to the appropriate table and go to design view and change it from a number box to a text box. Problem solved.