Access-Word Mailmerge Checkbox

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Janne - 19 May 2007 16:37 GMT

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 ?

Reply to this Message

Peter Jamieson - 19 May 2007 16:45 GMT

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

>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
[quoted text clipped - 3 lines]
> 2000 I get the result I want but in Access/Word 2003 I get no
> marked boxes, why ? What to do ?

Reply to this Message