Pedro Janssen
pedro at plex.nl
Mon Nov 24 14:28:42 CST 2003
Hello Group,
i use mailmerge for creating word-documents from access.
This is done by using code.
The following line is a peace of this code:
item("Drawing").value = Nz(Me![txtDrawing])
in word i use the following code with properties
{DOCPROPERTY "Drawing" \*MERGEFORMAT}
txtDrawing is a checkbox. In the word-document i get as result: -1 or 0
i would like Yes \ No or in Dutch Ja \ Nee
i tried things like:
item("Drawing").value = Format(Nz(Me![txtDrawing]), "Ja \ Nee")
or
{DOCPROPERTY "Drawing" \@"Ja \ Nee" \*MERGEFORMAT}
with no result.
How can i get the good format?
TIA
Pedro Janssen