Access checkboxes to Word merge not working

[leeann]

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

 

[Peter Jamieson]

In Word XP/2003 the default connection method for connecting to Access
changed from DDE to OLEDB. If you use the default method, YesNo fields
return "True" and "False" rather than numeric results.

You rally have two options: either change your IF fields to correspond to
the new values, or change the connection method by checking Word
Tools|Options|General|Confirm conversions at open and going through the
connection process again.

The full table of YesNo results for each connection method is:

Method Yes value No value
DDE 0 -1
ODBC 0 1
OLEDB True False

Peter Jamieson