Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-21-2015, 05:43 AM
DIYman DIYman is offline Problem with currency field code Windows 7 64bit Problem with currency field code Office 2013
Novice
Problem with currency field code
 
Join Date: Sep 2015
Posts: 5
DIYman is on a distinguished road
Default Problem with currency field code

Hi again,
In my mail merge document I have 3 fields identically formatted (I think) for currency indicating cent values (Code below). However the 1st field does not show the cents. I tried editing with various spaces etc. saved and closed end reopened but no success


Note I copied the code without the brackets (and added them here myself) as this was the only way I could cut and paste the code.

Code:
{ MERGEFIELD "Collection_Total"\#€,0.00 }
{ MERGEFIELD "Total_Dues"\#€,0.00 }
{ MERGEFIELD "Dues__Collection"\#€,0.00 }
Any advice.

Thanks in advance
Reply With Quote
  #2  
Old 09-21-2015, 08:22 PM
macropod's Avatar
macropod macropod is offline Problem with currency field code Windows 7 64bit Problem with currency field code Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

If all three fields have identical formatting switches, all three should generate the same output format. That said:
• problems of this kind often arise where the field in the data source contains mixed data types (e.g. text, plus numbers or dates). You can coerce such fields to perform numerically using the technique described under Force '0' Substitution for Empty/Missing Records in the Mailmerge Tips and Tricks Sticky thread at the top of this forum (https://www.msofficeforums.com/mail-...ps-tricks.html)
• there should be spaces around the numeric picture switches (e.g. { MERGEFIELD "Collection_Total" \# €,0.00 })
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 09-22-2015, 12:16 AM
DIYman DIYman is offline Problem with currency field code Windows 7 64bit Problem with currency field code Office 2013
Novice
Problem with currency field code
 
Join Date: Sep 2015
Posts: 5
DIYman is on a distinguished road
Default

Thanks, I'll recheck everything later as I'm at a different computer. My next move is to create a whole new document. I'll report back.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with currency field code Field Code won't print an image John Sutton Word 4 07-28-2014 08:40 AM
need an arbitrary field code ajetrumpet Word 1 07-15-2013 04:58 PM
Problem with currency field code Toggle Merge Field Code Help Please tonywatsonmail Mail Merge 2 08-11-2011 07:06 AM
Is there any way of importing Indicators field through code? Prabhakar Project 0 04-07-2011 05:50 AM
field code question bordercollie10 Mail Merge 3 10-15-2009 07:55 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:23 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft