By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,045 Members | 1,743 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,045 IT Pros & Developers. It's quick & easy.

Word Mail Merge

P: n/a
I am mail merging to Word. Some of my table columns are Yes/No data
types. I would like them to come out as check boxes in Word but they
merge as 0's and 1's
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
td*****@bu.edu (Tom Dauria) wrote in message news:<56**************************@posting.google. com>...
I am mail merging to Word. Some of my table columns are Yes/No data
types. I would like them to come out as check boxes in Word but they
merge as 0's and 1's


You'd have to create checkboxes in your Word form, I think, and then
use bookmarks to set the values... When you merge from Access to Word,
all it sends is *data*. (True=1, False=0). If you want it formatted,
you have to do that yourself or use checkboxes... AFAIK...
Nov 12 '05 #2

P: n/a
"Pieter Linden" <pi********@hotmail.com> wrote in message
news:bf**************************@posting.google.c om...
td*****@bu.edu (Tom Dauria) wrote in message

news:<56**************************@posting.google. com>...
I am mail merging to Word. Some of my table columns are Yes/No data
types. I would like them to come out as check boxes in Word but they
merge as 0's and 1's


You'd have to create checkboxes in your Word form, I think, and then
use bookmarks to set the values... When you merge from Access to Word,
all it sends is *data*. (True=1, False=0


In Access True is -1 usually, although any non zero value will be
interpreted as true by a check box control (if the check box is bound to an
integer field, for instance). Don't know if the same is true in Word.

Mike
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.