I need to be able to display a phone number as (123) 456-7890. The input
field is in an MS Access table as a text field.

When I use
{MERGEFIELD "office" \# "(###) ###-####"} or {MERGEFIELD "office" \# "(000)
000-0000"}

the results are (123) 456 7890....it's missing the dash ("-")

What am I doing wrong? Thanks in advance for your help!

Peter,

Try: "(###) ###'-'####"

with the hypen bounded wiht '




--
Greg Maxey/Word MVP
A Peer in Peer to Peer Support

PeterM wrote:
I need to be able to display a phone number as (123) 456-7890. The
input field is in an MS Access table as a text field.

When I use
{MERGEFIELD "office" \# "(###) ###-####"} or {MERGEFIELD "office" \#
"(000) 000-0000"}

the results are (123) 456 7890....it's missing the dash ("-")

What am I doing wrong? Thanks in advance for your help!

Thank you Greg...that worked perfectly!

"Greg Maxey" wrote:

Peter,

Try: "(###) ###'-'####"

with the hypen bounded wiht '




--
Greg Maxey/Word MVP
A Peer in Peer to Peer Support

PeterM wrote:
I need to be able to display a phone number as (123) 456-7890. The
input field is in an MS Access table as a text field.

When I use
{MERGEFIELD "office" \# "(###) ###-####"} or {MERGEFIELD "office" \#
"(000) 000-0000"}

the results are (123) 456 7890....it's missing the dash ("-")

What am I doing wrong? Thanks in advance for your help!