How can you Force "0s" in the field

  • Thread starter Thread starter emerlita
  • Start date Start date
E

emerlita

I have a field named Point Code, DataType of Number and has an
InputMask of 000\-000\-000;0;_
It looks like this -- 001-041-050 in the table view but when i tried
to show it in form view, it looks like this --
001-041-50 . How can i make this lokk like the format in table view?
 
I have a field named Point Code, DataType of Number and has an
InputMask of 000\-000\-000;0;_
It looks like this -- 001-041-050 in the table view but when i tried
to show it in form view, it looks like this --
001-041-50 . How can i make this lokk like the format in table view?
Click to expand...

That value is not a number value it is a text value (just as Social
Security and Phone Number's are).
Change the field's datatype to Text.
 
That value is not a number value it is a text value (just as Social
Security and Phone Number's are).
Change the field's datatype to Text.
Click to expand...

the thing is in other tables the input mask works the way i wanted it.
only in this particular form, it does not work.
 
Like the last poster stated, it isn't a number if there is a - stored in the
table. Try a test table ond only store the numbers not the dashes. If the
data is coming from a form place the input mask on it and only store the
values without the dashes.
 
Like the last poster stated, it isn't a number if there is a - stored in the
table. Try a test table ond only store the numbers not the dashes. If the
data is coming from a form place the input mask on it and only store the
values without the dashes.







- Show quoted text -
Click to expand...

thank you all. made sense.
 
Back
Top