Or do what Tom Rettig has done decades ago: have a location table with phone# mask.
Peter

>In the past I've had occasion to consider phone # formatting and I tink to do so is a danger. For instance, round where I live, the phone #s are of the form:
>
>01999 999999
>
>But in the big cities it's:
>
>091-999 9999
>
>But London is:
>
>020-9999 9999
>
>It was a few years ago that, in the first example, all exchange nos went from 0999 to 01999, as a result of mobile phones' introduction. London nos have gone through 2 transformations, starting as:
>
>01 999 9999.
>
>IOW, unless the database holds only local nos, of a definite format, I wouldn't format them, and I'd allow extra digits for future expansion.
>
>
>>

>>thisform.txtPhone.Format = 'R'
>>thisform.txtPhone.InputMask ='999-9999'

>>
>>This way the - symbol would not be stored in the phone and would be used for display only.
>>
>>>If my customer has typed phone number with and without the "-"
>>>as below
>>>
>>>221-4997
>>>222-3991
>>>222 3944
>>>223-6675
>>>222 3671
>>>
>>>How can I filter all 222-3, by I ignoring the "-"
>>>as all the numbers of the table had not the "-"
>>>using set filter