getting certain letters in a text box

[Dan]

I am exporting a phone number (saved as text) to another
office application (along with additional info) but for
some reason it won't transfer the input mask. If I could
get the first first 3 numbers, then the next 3 then the
final four I could just manually insert the correct
format, (###) ### - ####. How would you do this and do
you have any better sugestions on how to make it work?

 

[Cheryl Fischer]

Use a query as the data source from which to export and, in the query,
insert the following calculated field which will format the phone number:

NewPhone: Format([Phone],"(000) 000-0000")

Regarding input masks, if you use the wizard to create the input mask, there
is a prompt which asks if you want to save the data with or without the mask
symbols.