losing properties when merging

[Paul]

Can anyone tell me how I can keep my fieldproperties when
merging fields from a query in access to word ? Values
with two decimals in the query have four decimals after
beiing merged.

Thank you

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Add a \# "#,###.00" formatting switch inside the closing } of the mailmerge
field in the mailmerge main document. Use Alt+F9 to toggle on the field
codes.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP

 

[Paul]

Ok, this works, except now I 'lose' my zero. For
example : 0,66 becomes ,66. Can you also help me with
that ?

thanx

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Change the switch to

\# "#,##0.00"

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP

 

[Paul]

actually, the only way to keep two numbers behind the
decimal is when I use the following switch :

\# "#,##"

Using your second recommendation increases the number of
decimal places and doesn't restore the "0". Any more
suggestions ?

Thanx again

 

[Graham Mayor]

Do you live in a country that uses a comma as a decimal separator? In which
case, you need
\# "0,00"
Essentially you need to use 0 to force a 0 character for zero rather than #
which shows empty for zero.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>