Answered
allowing a zero as the first digit in an insert record form field
I have a form that has an insert record behavior applied to
it. I would like to be able to put a number into one of the form
fields that begins with the letter zero (i.e. 010507). The trouble
is that when I insert any number beginning with a zero, the first
zero in the number gets dropped when it is entered into the
database. This occured even when I tried changing the field type
from number to text in Access.