leading zero

[William Richard]

Hello,
I am trying to create a database for long distance access
codes. The codes have leading zeros such as 00123. After
creating the table in design mode with the fields needed I
built a form using the form wizard. I tried adding a
couple test records to build the reports with and when I
enter 00123 and press TAB to go to the next field it drops
the "00" and leaves "123" in the field. How can I make the
form retain the "00". Thanks for any help with this.

 

[Bruce M. Thompson]

I am trying to create a database for long distance access

codes. The codes have leading zeros such as 00123. After
creating the table in design mode with the fields needed I
built a form using the form wizard. I tried adding a
couple test records to build the reports with and when I
enter 00123 and press TAB to go to the next field it drops
the "00" and leaves "123" in the field. How can I make the
form retain the "00". Thanks for any help with this.

You'll need to change the data type for that field in the table to "Text" in
order to retain the leading zeros.