Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 03-09-2019, 05:12 AM
DarrenE DarrenE is offline Windows 10 Office 2016
Novice
 
Join Date: Mar 2019
Posts: 2
DarrenE is on a distinguished road
Exclamation Currency Field - Displaying Incorrect Value when Formatted

I have a mail merge in word from access (all 2016).

Before I apply the formatting, the data is displayed correctly @ 23.5.

However, when I apply the formatting: \# ,#.00 ~ MERGEFIELD "MyField" \# ,#.00 it displayed the value 28.00.



Any ideas would be appreciated, as it's driving me mad! I have fiddled with variances on \# ,#.00...
Reply With Quote
  #2  
Old Yesterday, 06:00 PM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,098
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Your description suggests the value in Access is stored as '23 5', not '23.5' and, that without the addition of the picture switch, what you're seeing in the output as '23.5' is actually '23 5' with the space shown as '.'. Clicking on the symbol on the Ribbon's Home tab to turn off the formatting display would likely confirm that.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old Today, 01:21 AM
DarrenE DarrenE is offline Windows 10 Office 2016
Novice
 
Join Date: Mar 2019
Posts: 2
DarrenE is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Your description suggests the value in Access is stored as '23 5', not '23.5' and, that without the addition of the picture switch, what you're seeing in the output as '23.5' is actually '23 5' with the space shown as '.'. Clicking on the symbol on the Ribbon's Home tab to turn off the formatting display would likely confirm that.
Thanks, Paul, but I don't think that is it.

In Access, my field is a currency field and when word opens it pulls only data of 23.5.

When I click the , all I see is at 28.00..
Reply With Quote
  #4  
Old Today, 02:54 PM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,098
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Quote:
Originally Posted by DarrenE View Post
when word opens it pulls only data of 23.5.

When I click the , all I see is at 28.00..
But what do you see when you click the when only the 23.5 is displayed?
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Tags
changing value, mergefield, wrong value

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Currency Field not showing $ and is rounding Juliesctt Mail Merge 3 07-05-2016 06:43 PM
Problem with currency field code DIYman Mail Merge 2 09-22-2015 12:16 AM
Problem Displaying Headers Using Field Codes OldProfessor Word 2 07-28-2015 07:51 PM
result of merge field is incorrect VHV Mail Merge 3 06-16-2014 03:46 PM
Displaying pictures from a field with a file path okiegirl Mail Merge 4 07-28-2012 02:14 AM


All times are GMT -7. The time now is 04:00 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft