C
Chaster
My table contains both a BusinessPhone and BussinessFax field. I must have
set up the table without applying a phone number mask and then later on
changed it to use the imput mask as I have 4000 records that display with
the mask and 626 that do not.
I have created a cboSelectFax that is based on a query that just pulls the
fax numbers sorted asending.
When I look at the data in the combo some numbers show as (212)-222-2222 and
others show as 2223334444
When I search for a number, that I know is in my table, that has the phone
number input mask
(212)-222-2222 format it will only allow me to put in the 1st 3 numbers
before the search fails. If the number I am searching does not have the
input mask it allows me to continue the search and finds the record.
I have now changed the field so there is no input masking done at the table
level
itself. I will apply the mask to my forms when necessary.
My questions are:
Any idea why I can only find the 1st 3 numbers when the data is in the (213)
format?
Is there a way to go back and replace the existing data that is in my table
as (213)-222-2222 with 2132222222
I need to remove the inputmask stuff ( )- - and just leave the numbers.
I tried creating a new table where the BusinessFax field did not have the
inputmask and then doing an append.
I am getting errors on 626 records that violate validation rules. Probably
the data that is my in table that is not formated with the inputmask.
Any help is appreciated.
set up the table without applying a phone number mask and then later on
changed it to use the imput mask as I have 4000 records that display with
the mask and 626 that do not.
I have created a cboSelectFax that is based on a query that just pulls the
fax numbers sorted asending.
When I look at the data in the combo some numbers show as (212)-222-2222 and
others show as 2223334444
When I search for a number, that I know is in my table, that has the phone
number input mask
(212)-222-2222 format it will only allow me to put in the 1st 3 numbers
before the search fails. If the number I am searching does not have the
input mask it allows me to continue the search and finds the record.
I have now changed the field so there is no input masking done at the table
level
itself. I will apply the mask to my forms when necessary.
My questions are:
Any idea why I can only find the 1st 3 numbers when the data is in the (213)
format?
Is there a way to go back and replace the existing data that is in my table
as (213)-222-2222 with 2132222222
I need to remove the inputmask stuff ( )- - and just leave the numbers.
I tried creating a new table where the BusinessFax field did not have the
inputmask and then doing an append.
I am getting errors on 626 records that violate validation rules. Probably
the data that is my in table that is not formated with the inputmask.
Any help is appreciated.