Multiple formats in the same field
Posted on 2013-11-09
An inherited Access db has Home phone, Cell phone, and Business phone fields. All fields have phone # as (xxx) xxx-xxxx or xxxxxxxxxx. Please tell me how to convert xxxxxxxxxx to (xxx) xxx-xxxx stored, visible, and able to be merged into a Word document. I would also like to know how to input new data so that these fields remain consistent. Do I use formatting or input mask? Thank you so much.