MergeField Formatting

[Guest]

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!

 

[Greg Maxey]

Peter,

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

with the hypen bounded wiht '

 

[Guest]

Thank you Greg...that worked perfectly!

Peter,

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

with the hypen bounded wiht '