If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
retain access format in word merge document?
How can I retain the Access format in a word merge document?
i.e data format in Access is 'Currency' when merged to Word the currency format is lost. same applys to 'Date' formats. |
#2
|
|||
|
|||
Use formatting switches in the Word field for the simplest approach -
http://www.gmayor.com/formatting_word_fields.htm If you want the more complicated approach see the Excel data section of http://www.gmayor.com/mail_merge_lab...th_word_xp.htm (the issues and workarounds are the same for Access). -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Rick Boon wrote: How can I retain the Access format in a word merge document? i.e data format in Access is 'Currency' when merged to Word the currency format is lost. same applys to 'Date' formats. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to embed Word document into Excel and retain sizing, formatti. | Kent | General Discussion | 0 | February 2nd, 2005 07:37 PM |
WORD XP mail-merge FAILS using ACCESS Query | SueMackay | Mailmerge | 1 | November 23rd, 2004 01:03 PM |
Merging MS Word document with MS Access 2002 criteria query | Doug Robbins | Mailmerge | 2 | November 4th, 2004 05:57 PM |
Word 2000/2002 - Proper Mail Merge steps for ODBC? | Tony_VBACoder | Mailmerge | 7 | September 2nd, 2004 09:21 PM |
Merge to Fax with SBS/Exchange? | Tom | Mailmerge | 3 | May 18th, 2004 11:22 PM |