View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
leeann leeann is offline
external usenet poster
 
Posts: 1
Default Access checkboxes to Word merge not working

I have an Access 2000 database that is the source for Word 2000 mailmerge.
Recently my computer was upgraded to Windows XP, running Office 2003. Most
everything appears to still work (shock and awe), except for the checkboxes.
I have a bunch of if/then/else statements that put statements into my
document when the box is checked. One reads: { IF { MERGEFIELD Option1 ]
0 "30/60 Rating Plan with the Ultra Preferred discount." "" }{ IF {
MERGEFIELD Option2] 0 "30/60 Rating Plan with the Conviction Free discount.
" "" }{ IF { MERGEFIELD Option3] 0 "30/60 Rating Plan." "" } So this
worked just fine, in that the statements in quotes would show up in my
document if and only if the corresponding checkbox in Access was checked.

Now, running under Offices 2003, the above statements give me what is in the
quotes, whether or not the checkboxes in Access are checked. I've attempted
to change the to greater than, less than, equal to, etc., while changing
the 0 to 0 or -1 in various combinations, but either I get always get the
sentences in quotes, or never do.

A solution would be wonderful, as would any other tips at moving this stuff
from Word and Access 2000 to 2003. Thanks