Field Size and Input Mask

  • Thread starter Thread starter chicagoro
  • Start date Start date
C

chicagoro

I created forms in Access2000 (Win98) using the Wizard.
Two boxes are for telephone numbers. The input mask is
!\(999")"000\-0000. After I enter the phone number, it
won't let me tab to the next field or continue in the form
in any way. The error message that comes up is "The value
you entered isn't valid for this field. For example, you
may have entered text in a numeric field that is larger
than the Field Size setting permits." I've tried the Help
Index but I can't find where the field size settings are
if that's the problem.
 
With the input mask you have listed, the characters in the mask shouldn't be
getting stored, so the field size needs to be 10 or larger. If you place a 0
in the next argument of the input mask, then the characters would be stored
also and the field size would need to be 14 (i.e. !\(999")"000\-0000;0;_).
Also, a phone number isn't really a "number" (you usually don't do
arithmetic with it). Make the field a text field.
 
Back
Top