Skip to main content
Inspiring
January 23, 2007
Answered

allowing a zero as the first digit in an insert record form field

  • January 23, 2007
  • 1 reply
  • 252 views
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.
This topic has been closed for replies.
Correct answer aonefun
Oh, I failed to change the field type to "text" in the insert record dialogue box as well.

1 reply

aonefunAuthorCorrect answer
Inspiring
January 23, 2007
Oh, I failed to change the field type to "text" in the insert record dialogue box as well.