One way to handle this is:
- use a C(10) field to store the number
- use 999-999-9999 as the Inputmask (as you've already done)
- use "R" as the Format code (ignore input mask). This causes the value to be stored in the field without the hyphens.
>I have a TextBox for a phone number whose InputMask property reads '999-999-9999'.
>
>Under VFP3 this TextBox allowed the user to key in 2124567890 and it would display as 212-456-7890. The Value of the TextBox also would read '212-456-7890'.
>
>Now that I've upgraded the app to VFP6, the TextBox does not allow anything to be entered after the first 3 digits (e.g. 212).
>
>I can't find any documentation in either VFP3 or VFP6 that says you can use the hyphen in the InputMask the way I did. In fact, I can't remember what pocessed me to do it in the first place. Had I simply stumbled upon something undocumentated that worked under 3.0, but not under 6.0 ?
>
>- Werner
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up