[Ransom]

Hello,
I am trying to format a merge field in Word 2003.

I have the telephone field placed but once the merge occurs from Access the
number shows like this 3019251788. How can I get it to display like this
(301) 925-1788 or 301-925-1788?? HELP

Thanks
Ransom

[Graham Mayor]

You need a switch on the merge field. Toggle the display with ALT+F9 and
change the {Mergefield PhoneNoField} to
{Mergefield PhoneNoField \# "(000) 000'-'0000"}
or
{Mergefield PhoneNoField \# "000'-'000'-'0000"}
depending on which layout you prefer
Then F9 to update and ALT+F9 to toggle again

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Ransom wrote:
Hello,
I am trying to format a merge field in Word 2003.

I have the telephone field placed but once the merge occurs from
Access the number shows like this 3019251788. How can I get it to
display like this (301) 925-1788 or 301-925-1788?? HELP

Thanks
Ransom

[Ransom]

Thank you!! worked like a charm

"Graham Mayor" wrote:

You need a switch on the merge field. Toggle the display with ALT+F9 and
change the {Mergefield PhoneNoField} to
{Mergefield PhoneNoField \# "(000) 000'-'0000"}
or
{Mergefield PhoneNoField \# "000'-'000'-'0000"}
depending on which layout you prefer
Then F9 to update and ALT+F9 to toggle again

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Ransom wrote:
Hello,
I am trying to format a merge field in Word 2003.

I have the telephone field placed but once the merge occurs from
Access the number shows like this 3019251788. How can I get it to
display like this (301) 925-1788 or 301-925-1788?? HELP

Thanks
Ransom

[Graham Mayor]

You are welcome

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Ransom wrote:
Thank you!! worked like a charm

"Graham Mayor" wrote:

You need a switch on the merge field. Toggle the display with ALT+F9
and change the {Mergefield PhoneNoField} to
{Mergefield PhoneNoField \# "(000) 000'-'0000"}
or
{Mergefield PhoneNoField \# "000'-'000'-'0000"}
depending on which layout you prefer
Then F9 to update and ALT+F9 to toggle again

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Ransom wrote:
Hello,
I am trying to format a merge field in Word 2003.

I have the telephone field placed but once the merge occurs from
Access the number shows like this 3019251788. How can I get it to
display like this (301) 925-1788 or 301-925-1788?? HELP

Thanks
Ransom