Currency Field - Displaying Incorrect Value when Formatted

macropod · #1 03-18-2019, 06:00 PM

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.

DarrenE · #2 03-19-2019, 01:21 AM

Quote:

Originally Posted by macropod

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.¶.

macropod · #3 03-19-2019, 02:54 PM

Quote:

Originally Posted by DarrenE

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?

DarrenE · #4 03-19-2019, 04:43 PM

I see: £28.00.¶

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