not able to enter 0's

[Jesse]

I set up the data base so that reciet numbers is one of
the fields. The field data is numbers. I have placed the
validation rule to be Like "######" but when I eneter a
number like 0004321 it will not record the data. How can I
set up the field properties so that there can be 0's
placed in that field. All of our reciepts are 6 digits but
some of them start with multiple zeros. thanks in advance.

 

[John Vinson]

I set up the data base so that reciet numbers is one of
the fields. The field data is numbers. I have placed the
validation rule to be Like "######" but when I eneter a
number like 0004321 it will not record the data. How can I
set up the field properties so that there can be 0's
placed in that field. All of our reciepts are 6 digits but
some of them start with multiple zeros. thanks in advance.

Use a Text datatype field (rather than a number) - you will *never* do
arithmatic with receipt numbers! You can set the field's Input Mask
property to 000000 to force entry of six digits.