Phone Numbers

  • Thread starter Thread starter Trisha
  • Start date Start date
T

Trisha

We have a table that contains telephone numbers, but they
aren't formatted as telephone numbers. For example, if
the phone number was 555-555-1212, in our table it is
listed as 5555551212. We want to create a report that
displays it as a phone number. Now I know I can use Left
String, mid, etc, but I was hoping there was an easier
way. Please keep in mind the table we are using is read-
only, so it must be changed in a query or report.

Thanks for your help,
Trisha
 
Trisha,

In the design view of a report, you can set the Input Mask property of the
control containing the telephone number to:

!\(999") "000\-0000;0;_

and it will display the phone number 5555551212 as (555) 555-1212.

hth,
 
Back
Top