Null values

[Jean Paul Gevaert]

I have an access table with some numeric values in it. Some of them have the value Nul

When I do a mail merge with word XP sp3 null values are translated to 0, I don't have the problem with other word versions (98, 2000 ...

Jean Pau

 

[Doug Robbins - Word MVP]

If you check the "Confirm conversion at Open" box under
Tools>Options>General and try a different connection method, you may be able
to restore the previous behaviour, or, if you toggle on the field codes and
add the following formatting switch inside the closing }, the 0's will not
be displayed

\# "#;(#);"

modify the formatting inside the "" to get what you want

For exampe

\# "#.00;(#.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

I have an access table with some numeric values in it. Some of them have the value Null

When I do a mail merge with word XP sp3 null values are translated to 0, I

don't have the problem with other word versions (98, 2000 ...)

 

[Jean Paul Gevaert]

Using the formatting method you explained gives no solution because the value 0 exists also. I tried already the second solution, it give me no result. Especially the word file is called from within Access and I don't want the user to chose his connectio

J

 

[Doug Robbins - Word MVP]

In that case, you will probably have to use and If ... Then ... Else field
construction in the mailmerge main document and maybe also you might need to
crate a Null to something function in Access and use that in a query to set
the null values to some unlikely number (I assume that it is a numeric
field). However, thinking about it now, if you use the Format ()function in
an Access query, that will cause the data to be considered as text and it
may then merge how you want it to.

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

Using the formatting method you explained gives no solution because the

value 0 exists also. I tried already the second solution, it give me no
result. Especially the word file is called from within Access and I don't
want the user to chose his connection