I have a database (MS Access 2003) where the user imported from MS Excel 2003 and then updated an existent table in the database. The table has a field with the input mask for a phone number !\(999") "000\-0000;0;_
The problem I've noticed is that some records are now showing the phone number not in the correct format. They show as parentices without dashes.
How do I update the field to show all records in the correct format? (with parentices and dashes).
Rey Obrero (Capricorn1)
8/22/2022 - Mon
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!