Access-Word Mailmerge Checkbox

[Janne]

I have problem when I want to update a db from Access 2000 to
2003. I use Mailmerge to print out records in Word. Everything
is ok except the Checkboxes. I use 'if then else' in
Insert/Field command and get this command {If {mergefield
CheckBox1}= "-1" "marked box" "unmarked box"}. In Access/Word
2000 I get the result I want but in Access/Word 2003 I get no
marked boxes, why ? What to do ?

 

[Peter Jamieson]

It's because Word 2000 and Word 2003 use different connection methods (by
default) to get data from Access, and the two methods return "Yes/No" values
in different ways.

In Word 2003, try

{ IF { MERGEFIELD Checkbox1 } = "True" "marked box" "unmarked box" }

Peter Jamieson