Format Fields in Word document

[Tricia]

I mail merge client info from our Access database into Word. How do I format
the fields?

Example - Time is displayed as 24 hours in Access (13:23), but comes through
as 12 hour clock in form fields (1:00 PM), telephone numbers come through
without brackets or dashes 5191234567

Thanks for any assistance

 

[Peter Hibbs]

Tricia,

Have a look at http://word.mvps.org/FAQs/MailMerge/index.htm

HTH

Peter Hibbs.

 

[John W. Vinson]

I mail merge client info from our Access database into Word. How do I format
the fields?

Example - Time is displayed as 24 hours in Access (13:23), but comes through
as 12 hour clock in form fields (1:00 PM), telephone numbers come through
without brackets or dashes 5191234567

Thanks for any assistance

Base the mailmerge - not directly on your table - but on a Query. Use the
Format() function to cast the fields into strings for the mailmerge - e.g.
instead of using the [Phone] field use

ShowPhone: Format([Phone], "(@@@) @@@-@@@@")