trying to keep phone # format from Access to Word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

- 11 Mar 2004 14:34 GMT

I'm trying to merge records from Access in to Word and
when it's done the phone # format does not follow, it just
ends up as 10 numbers, I've tried formatting the record
using these two methods
{ Mergefield Phone \# "(000)'-'000'-'0000" }
Format([Phone], "(000)-000-0000")
but they don't work.

Reply to this Message

Graham Mayor - 11 Mar 2004 21:34 GMT

See http://www.gmayor.com/formatting_word_fields.htm
{ Mergefield Phone \# "(000)'-'000'-'0000" } works for me. Did you update
the field (F9) after adding the switch?

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I'm trying to merge records from Access in to Word and
> when it's done the phone # format does not follow, it just
[quoted text clipped - 3 lines]
> Format([Phone], "(000)-000-0000")
> but they don't work.

Reply to this Message

Lisa - 15 Mar 2004 20:05 GMT

I'm unable to get the phone # to format and I'm also
missing numerous records after the merge... is it possible
that because I have Access 2000 and Word XP that there is
a compatibility issue here?

>-----Original Message-----
>See http://www.gmayor.com/formatting_word_fields.htm
[quoted text clipped - 10 lines]
>
>.

Reply to this Message

Graham Mayor - 16 Mar 2004 07:55 GMT

It's a puzzle - however checkout the Excel data section of
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm (Excel & Access
have basically the same issues) and see if that helps.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I'm unable to get the phone # to format and I'm also
> missing numerous records after the merge... is it possible
[quoted text clipped - 23 lines]
>>
>> .

Reply to this Message