Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Janne Janne is offline
external usenet poster
 
Posts: 1
Default Access-Word Mailmerge Checkbox

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 ?


  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Access-Word Mailmerge Checkbox

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" wrote in message
...
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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MailMerge from Access to Word 2003 [email protected] Mailmerge 10 May 30th 07 04:04 AM
insert checkbox on if condition in mailmerge wqyne elliott Mailmerge 6 December 15th 06 06:20 PM
Mailmerge from MS Access to Word JimMurray Mailmerge 1 June 25th 06 07:02 AM
Word Mailmerge with Access via DDE Jim Gilligan Mailmerge 0 November 22nd 05 02:21 PM
Mailmerge using Word and Access 2003 Chester1 Mailmerge 1 October 5th 05 12:47 PM


All times are GMT +1. The time now is 06:44 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"