Input Mask into Text Box - Phone Number - Help!

[Curtis Stevens]

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

 

[strive4peace]

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]

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....

 

[strive4peace]

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]

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

 

[strive4peace]

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]

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

 

[strive4peace]

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]

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

 

[Curtis Stevens]

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

 

[strive4peace]

glad you got it, Curtis happy to help

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com

 

[Curtis Stevens]

It was a stupid space that you couldn't see that was after the number, the
()- didn't matter, that darn space!

 

[strive4peace]

thanks for letting me know

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com