They can be used all jammed together at the interface with the "R" format property and "(999) 999-9999" InputMask.
If you want to
store them that way, try REPLACE home_phone WITH "("+are_phone+") "+phone_3+"-"+phone3
>I used to have three different fields for my phones, ex: Are_phone (3), Phone_3(3) and Phone_4(4) instead of just one field with all the 10 digits in it. Now I created a new field called Home_Phone(15) and I replaced all the old 3 fileds into one single field called Home_phone; however, the numbers are all closed together ex: 7034485656 and I would like to know if I could separate them so it would make easier for my user to read them ex: 703 448 5656, it could be separeted by a space, dash or ( ). It would not matter to me.
>If anyone can help i would really appreciated it, and thank's in advance
>Eduardo
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05