I formatted a phone number (I think this was done after the numbers were imported into the database) - the format shows up correctly in the table and in forms, but not in a report - not until I edit or change the number, then it shows up correctly in the reports. I have over 3,000 numbers and I would like to find a way to edit the numbers without doing it manually one at a time. I wrote a program in VBA to copy the existing phone number - change the number to null - update the record - and then copy the number back. I still do not have the format in reports, just 10 straight digits. Can anyone help me? Thanks