Group:  Microsoft Word ยป microsoft.public.word.mailmerge.fields
Thread: Access-Word Mailmerge Checkbox

Geek News

Access-Word Mailmerge Checkbox
"Janne" <janne.tyko[ at ]telia.com> 5/19/2007 3:37:01 PM
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 ?


Re: Access-Word Mailmerge Checkbox
"Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 5/19/2007 3:45:35 PM
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

"Janne" <janne.tyko[ at ]telia.com> wrote in message
news:%23LtGItimHHA.4772[ at ]TK2MSFTNGP05.phx.gbl...
[Quoted Text]
>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 ?
>
>

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net