Input Mask into Text Box - Phone Number - Help!

I have a text field name phone number. I gave the text box in my forms an
input mask for phone number.

I used this: !\(999") "000\-0000;0;_

It works, but I get customer's info from my online forms and past the info
into my database - all the data is tab delimited, but when I past it which
the data is in this format (111) 123-1234, it comes up with error saying the
value you entered isn't appropriate for the input mask such and such.

Now, the text field in the database is said to TEXT, no format or input
mask. I tried this way, error. I gave it an input make of the same, error.
I tried doing !\(999") "000\-0000;;_ and nothing.

Does all this make sense, thanks for your help!!!!!

Curtis

perhaps you are picking up a space/tab before or after the
phone number...

how are you doing the paste?

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com


Curtis Stevens wrote:
> I have a text field name phone number. I gave the text box in my forms an
> input mask for phone number.
>
> I used this: !\(999") "000\-0000;0;_
>
> It works, but I get customer's info from my online forms and past the info
> into my database - all the data is tab delimited, but when I past it which
> the data is in this format (111) 123-1234, it comes up with error saying the
> value you entered isn't appropriate for the input mask such and such.
>
> Now, the text field in the database is said to TEXT, no format or input
> mask. I tried this way, error. I gave it an input make of the same, error.
> I tried doing !\(999") "000\-0000;;_ and nothing.
>
> Does all this make sense, thanks for your help!!!!!
>
> Curtis
>

I open up my table, go to the very bottom or click the >* button. Click on
the far left column, what do you call it? When you click on it, it selects
that row, I then hit paste....


> perhaps you are picking up a space/tab before or after the
> phone number...
>
> how are you doing the paste?
>

the left box is called the record selector

if you pasted the field in alone, it would be okay, but the
InputMask is interferring... you say you deleted the
InputMask from your table design?

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com


Curtis Stevens wrote:
> I open up my table, go to the very bottom or click the >* button. Click on
> the far left column, what do you call it? When you click on it, it selects
> that row, I then hit paste....
>
>
>
>>perhaps you are picking up a space/tab before or after the
>>phone number...
>>
>>how are you doing the paste?
>>

Record selector, geeze, I need to go to bed!

Yes, Phone number field in my database has no inpdut mask, all those
settings are blank, input, format, etc.

Curtis


> the left box is called the record selector
>
> if you pasted the field in alone, it would be okay, but the
> InputMask is interferring... you say you deleted the
> InputMask from your table design?
>

Hi Curtis,

Perhaps there is another way to transfter the data... how
are you getting the info to copy and paste?

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com


Curtis Stevens wrote:
> Record selector, geeze, I need to go to bed!
>
> Yes, Phone number field in my database has no inpdut mask, all those
> settings are blank, input, format, etc.
>
> Curtis
>
>
>
>>the left box is called the record selector
>>
>>if you pasted the field in alone, it would be okay, but the
>>InputMask is interferring... you say you deleted the
>>InputMask from your table design?
>>

I use a php form and the only would I could figure out to do it that was
possible for me is all the data is tab delimited. Like take all the fields
in excel, insert values, past that in an email and that is how the data comes
in, data tabbed, so each one represents a field space or whatever you call
it. So when you copy & past, it pastes the info into the fields, but
apparently isn't taking mine saying not the right format. But if the forms
have an input maks, I wouldn't think this has anything to do with pasting
data into the TABLE?

Thanks
Curtis

> Perhaps there is another way to transfter the data... how
> are you getting the info to copy and paste?
>
> Have an awesome day
>

I agree, if you do not have an InputMask in the table, there
should not be a problem... how long it the Phone field
defined to be?

why not import the data from the text file and use an Append
query to move it? Then you can skip the Excel step

Copying and pasting is not the best way to do this...


Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com


Curtis Stevens wrote:
> I use a php form and the only would I could figure out to do it that was
> possible for me is all the data is tab delimited. Like take all the fields
> in excel, insert values, past that in an email and that is how the data comes
> in, data tabbed, so each one represents a field space or whatever you call
> it. So when you copy & past, it pastes the info into the fields, but
> apparently isn't taking mine saying not the right format. But if the forms
> have an input maks, I wouldn't think this has anything to do with pasting
> data into the TABLE?
>
> Thanks
> Curtis
>
>
>>Perhaps there is another way to transfter the data... how
>>are you getting the info to copy and paste?
>>
>>Have an awesome day
>>

Crystal,

To make sure we are on the same page, I don't use Excel, was trying to
explain how the data comes to me. Type in a letter in a bunch of colums, but
the same row. Then select all those colums/same row and paste it into a
plain email, that is how it comes. So I just select all the text, hit the
record selector in my table and paste. I don't know of any other way to do
it that would be more automated?

In short, that is how the data comes to me in my, I copy and paste into my
table. Couple of clicks.

Curtis

> I agree, if you do not have an InputMask in the table, there
> should not be a problem... how long it the Phone field
> defined to be?
>
> why not import the data from the text file and use an Append
> query to move it? Then you can skip the Excel step
>
> Copying and pasting is not the best way to do this...
>
>
> Have an awesome day
>
> Warm Regards,
> Crystal
>
> MVP Microsoft Access
>
> remote programming and training
> strive4peace2006 at yahoo.com
>
>
> Curtis Stevens wrote:
> > I use a php form and the only would I could figure out to do it that was
> > possible for me is all the data is tab delimited. Like take all the fields
> > in excel, insert values, past that in an email and that is how the data comes
> > in, data tabbed, so each one represents a field space or whatever you call
> > it. So when you copy & past, it pastes the info into the fields, but
> > apparently isn't taking mine saying not the right format. But if the forms
> > have an input maks, I wouldn't think this has anything to do with pasting
> > data into the TABLE?
> >
> > Thanks
> > Curtis
> >
> >
> >>Perhaps there is another way to transfter the data... how
> >>are you getting the info to copy and paste?
> >>
> >>Have an awesome day
> >>
>

Thanks Crystal, got it figured out now.

I just changed the format of the numbers that I copy from my emails. My
forms are setup to send the numbers in this format (123) 123-1234 so that was
problem, just change it to 1231231234 and it works just fine. I changed the
input mask of the table to phone number format too as well as the forms so it
looks like a number & no prob!

Curtis