phone number input mask

Hi all,
Access gives me this as an input mask for a phone number: !\(999")
"000\-0000;0;_ This works fine for a 10 digit number but not when there is
only a 7 digit number (no area code). Is there a way to write this so that
it will accept both 10 and 7 digit numbers?
Thanks!
LGarcia

Access gives me this as an input mask for a phone number: !\(999")
"000\-0000;0;_ This works fine for a 10 digit number but not when there is
only a 7 digit number (no area code). Is there a way to write this so that
it will accept both 10 and 7 digit numbers?

That's odd, because in that pattern, the 9 represents optional input. I
tried out your input mask and let lets me exclude the area code just fine.
But I would be more concerned that a 7 digit number might accidentally get
entered like this:

(123) 456-7___

--
Peace & happy computing,

Mike Labosh, MCSD

Feed the children!
Save the whales!
Free the mallocs!

That's what I'm trying to avoid. I think I need the entry to go right to
left instead of left to right. I moved the exclamation all around but I get
nothing. - thanks for the reply


"Mike Labosh" wrote in message
...
Access gives me this as an input mask for a phone number: !\(999")
"000\-0000;0;_ This works fine for a 10 digit number but not when there
is
only a 7 digit number (no area code). Is there a way to write this so
that
it will accept both 10 and 7 digit numbers?

That's odd, because in that pattern, the 9 represents optional input. I
tried out your input mask and let lets me exclude the area code just fine.
But I would be more concerned that a 7 digit number might accidentally get
entered like this:

(123) 456-7___

--
Peace & happy computing,

Mike Labosh, MCSD

Feed the children!
Save the whales!
Free the mallocs!

That's what I'm trying to avoid. I think I need the entry to go right to
left instead of left to right. I moved the exclamation all around but I
get
nothing. - thanks for the reply

To get the entry to go from right to left, I think you want to remove the
exclamation point, not put it somewhere else.
--
Peace & happy computing,

Mike Labosh, MCSD

Feed the children!
Save the whales!
Free the mallocs!

LGarcia wrote:
Hi all,
Access gives me this as an input mask for a phone number: !\(999")
"000\-0000;0;_ This works fine for a 10 digit number but not when
there is only a 7 digit number (no area code). Is there a way to
write this so that it will accept both 10 and 7 digit numbers?
Thanks!
LGarcia

Dump the thing and format the output.
@@@ @@@-@@@@ works just fine and your users won't be frustrated having to
move the cursor if they click on the field in the wrong place.
If you insist on it teach them to click on the label rather than the field.