not able to enter 0's

  • Thread starter Thread starter Jesse
  • Start date Start date
J

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.
 
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.
Click to expand...

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.
 
Back
Top