Need help with input mask

[pokdbz]

I have a input mask of 000\-00\-0000;0;_ for a SSN. My SSN is a text field.
But there is a problem if I put in all 0's 000-00-0000 it comes up as 0 and
nothing else. How can I display the whole number?

 

[Chaim]

Your field is numeric, not text. Using your format and a text field, you
will see 000-00-0000. As a numeric, you will see: - -0 .

 

[pokdbz]

The field is text. and on the form is where i am having the problem with the
formatting in the in put mast for the text box I have 000\-00\-0000;0;_

 

[pokdbz]

So how do I change this I remobed the input mask and put 000\-00\-0000;0;_
into the format of the text box and it is still giving me the same problem.

 

[AL FINK]

Make sure your field is a text field and not a number on the table, if it
is text when you enter 000/00/000 you should see the same thing unless you
have a format command some place changing the format. like of a form or
control.
If you are seeing the 0 on a form check to see if the format is the same in
the table if not the open the form in design view and check the control
properties for the format property and see what that is set to. I hope this
helps