numeric picture: formating merge field without rounding decimal digits?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rookie07 - 28 Feb 2006 10:03 GMT

hello,

i'm not very used to ms word and have a problem concerning formating a
merge field with a numeric picture...

my datasource is a ms access db, especially a numeric (double) field
which for example contains a value like: 9957,7992. in the mail merge
this value should be displayed as a currency value like: 9.957,79 USD
(i'm from europe/austria).
so i did something like this: {MERGEFIELD MyDBField \# "#.00,00
USD;(#.00,00 USD)"} in order to format this field.

so the big probelm i have ist the output: 9.975,80 USD was rounded but
i need the original value: 9.975,79 USD.

is anyone out there who can help me with this?

THANX!!!

Reply to this Message

Cindy M -WordMVP- - 28 Feb 2006 12:46 GMT

Hi Rookie07,

This would be better done on the Access side, using an expression in a
Query. Word doesn't provide a lot of good, strong functionality for
dealing with field content, while with Access you have a number of VB(A)
functions you can integrate into queries.

I suggest you try something like this:

Amt: (Int({AmountFieldName}*100)/100)

> i'm not very used to ms word and have a problem concerning formating a
> merge field with a numeric picture...
[quoted text clipped - 10 lines]
>
> is anyone out there who can help me with this?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail :-)

Reply to this Message

rookie07 - 28 Feb 2006 14:59 GMT

hello,

thank you for your reply!!!

i think i finally made it with this code:

{SET A"{MERGEFIELD "zahl"}"}{SET B "{=INT(A*100)/100}"}{B\# "#.00,00
USD;(#.00,00 USD)"}

THANX!!!

Reply to this Message

Rate this thread: