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!!!

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

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?


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 :-)

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!!!