Valid Phone Number Checking

[graviz]

Does anyone have some good code to validate if a phone number is valid in a table. I know how to validate the length, isnumeric, and entires like 111-111-1111. Does anyone have a more advanced section of validation code for such a task?

 

[HiTechCoach]

IMHO, the issue will be in building a master list of all the valid area codes and the exchanges withing these area codes.

If you have a master list, on the data entry form, I would use cascading combo boxes to select the valid area code then exchange.

 

[graviz]

I don't have a master list which is part of the problem. Also I'm just using it against a table that has data in it already so a form is not necessary. Does anyone have such a list?

 

[Steve R.]

I don't have a master list which is part of the problem. Also I'm just using it against a table that has data in it already so a form is not necessary. Does anyone have such a list?

Area Code Listing, by Number The page was last updated in July 2008.

 

[HiTechCoach]

Area Code Listing, by Number The page was last updated in July 2008.

Steve,

Thanks for the link!