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