PC Review


Reply
Thread Tools Rate Thread

Access/Word Merge

 
 
=?Utf-8?B?TmFuY3lILUQ=?=
Guest
Posts: n/a
 
      28th Mar 2007
How can you make Access field formats show up in a merged Word document?
(For example, wanting a currency field in Access to show up in a Word
document as currency with 2 decimals)
 
Reply With Quote
 
 
 
 
Douglas J. Steele
Guest
Posts: n/a
 
      28th Mar 2007
Try using the Format function in a query and merge the query, rather than
setting the Format property in the field.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"NancyH-D" <NancyH-(E-Mail Removed)> wrote in message
news:F25AC386-24A5-4847-9B29-(E-Mail Removed)...
> How can you make Access field formats show up in a merged Word document?
> (For example, wanting a currency field in Access to show up in a Word
> document as currency with 2 decimals)



 
Reply With Quote
 
Peter Hibbs
Guest
Posts: n/a
 
      28th Mar 2007
You could do the formatting in the Word document itself, have a look
at -
http://word.mvps.org/FAQs/MailMerge/index.htm

which shows how to format mail merge fields in Word.

HTH

Peter Hibbs.

On Wed, 28 Mar 2007 13:42:00 -0700, NancyH-D
<NancyH-(E-Mail Removed)> wrote:

>How can you make Access field formats show up in a merged Word document?
>(For example, wanting a currency field in Access to show up in a Word
>document as currency with 2 decimals)

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
merge access ole into word or publisher mail merge sierralightfoot Microsoft Access 4 10th Apr 2008 10:26 PM
run mail merge to word from ms access using and save every record as separate word document Rasta Microsoft Access 0 12th Dec 2007 11:22 PM
Mail merge: Word/Access ok but Access/Word is problem =?Utf-8?B?S2V2cnls?= Microsoft Access 4 11th Jul 2006 02:38 AM
Word Merge From Access =?Utf-8?B?S2F0aHkgU29ydG9y?= Microsoft Access VBA Modules 2 19th Jan 2005 08:13 PM
Merge a Query from within Access to a Word Mail Merge Main Doc Rebecca Microsoft Access VBA Modules 3 22nd Nov 2003 01:16 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:47 PM.