use mail merge to put the yes no checkboxes from access to word

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to mail merge an access table into word. I want the YES and NO
checkboxes to show as ticks in the word document, but they appear as -1. How
can I resolve this?
Amanda
 
Yes/No values (more accurately True/False values) are actually stored as -1
and 0 respectively. Since what's being transferred to Word is the data,
that's all that Word knows about. You'd have to format the data in Word
itself, and unfortunately, I can't tell you how to do that. You may be able
to get help in one of the many Word newgroups.
 
IIF(boolean01= -1,"Yes", "No")
Use this in access in a new text filed and use this text filed in word.
Sumit
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging Data into Word and Want Checkboxes (Yes/No data type) 1
mail merge using a check box field 3
Get selected word documents from user's choice and merge those documents as a single doc file 0
Mail Merge using ACCESS 3
Merge from Access to Word - Loses Data Source 2
SP3 and Mail Merge 1
UK dates in database appearing as US dates in a mail merge document 2
Mail merge to word from access 1

Back
Top