Format Phone Number

[Jessie]

Hello.

I have a phone field formatted:

9995551212 that I have to change to:

(999)555-1212 on fixed width text output. Is there a way I
can do this using a query?

Thanks,
Jessie

 

[John Vinson]

Hello.

I have a phone field formatted:

9995551212 that I have to change to:

(999)555-1212 on fixed width text output. Is there a way I
can do this using a query?

Use the Format() function: put in a calculated field by typing

ExpPhone: Format([phone], "(@@@)@@@-@@@@")

and export the resulting text string.

Note that setting the Format *property* of a field or form/report
control doesn't help with exports - the export software ignores it.