No, I am getting a number from a web page and copying it, then pasting it to the forms telephone number field. I was hoping that there would be a simple anser for this, but perhaps I need to have an unbound field, to which I copy the formatted telephone number then when I do something like double click it, strips the unwanted characters and then I can copy and pasted it to the telephone field. If it is only numbers say 8005551212 it will copy perfectly.
You are on the right track with that.
Your first step is to create a small sample database with a single table called "tblTel" to hold the telephone numbers.
Create a form based on "tblTel" which will have a field displayed in it where you can enter the telephone number into the telephone field in "tblTel"
Add an unbound text box.
Add a command button.
To test that a command button is working right, add the code to have the command button open a message box saying 'hello" .
Now change the command button code so that it takes text from the unbound textbox and shows it in the message box.
Change the command button code so that it takes the text of the unbound textbox and places it in the bound text box.
Look at the code I posted a link to earlier, the stripper function. Copy it and paste it into your form module next to the command button code.
Change the command button code yet again so that it Calls this function and also passes the unbound text box contents into the stripper function as a parameter and returns the result into the bound text box.
Everytime any of these steps fail, and it will, post here for help and I am sure someone will point you in the right direction.