Merge field formats in Word

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

melonhead

Thread Starter
Joined
May 6, 2002
Messages
882
I'm using Office XP. I have a document merged with Access. Inside the Word document some of the merged fields are text, and some of the merged fields are currency. In earlier versions of Word, the merged results would be the same format as the format used in Access, ie. if you had a data entry in Access that was $5.00 it would show up as $5.00 in the merged field in Word. However, I cannot get the merged field in XP to show up as currency. It only is shown as The fields that are currency will not show up as a currency value, only as a regular number. I tried the numeric picture field switch in Word help, but that didn't work either. I have these merged fields in a table. However, I have also tried them not in a table with the same result.

While I'm asking, I would also like a field not to show up in Word if it is equal to $0.00. Is there any easy way to do that?

Thanks in advance!
 

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,749
{ MergeField "Amount" \# "$#,000.00" }


And then probably for the whole shi-bang:

{IF{MergeField "Amount" = 0,"",{ MergeField "Amount" \# "$#,000.00" } }
 

melonhead

Thread Starter
Joined
May 6, 2002
Messages
882
Thanks! You are awesome. I always read your responses and learn from they. You are like the Office Queen.

The first equation worked, but the second one did not. It keeps showing the {If 0. I don't want it to show anything if the value is zero.

Why did Microsoft make this so difficult? It was so easy before! I would think they would be getting lots of complaints. I know I will be visiting their website. Hopefully they'll get a patch.

I've got two sick kids and so I've got to go. I'll check back later and see if you have any other suggestions!

Thanks again.
 

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,749
Try this then:

{IF{MergeField "Amount" = "0","",{ MergeField "Amount" \# "$#,000.00" } }

...I added quotes around that lone zero.

(Changed the title of your question to be more appropriate for searchers...)
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top