Replace True/False with Yes/No in Word Merge from Access Database

The problem exporting Yes/No fields from Access is that they appear in a Word Merge as True/False.  I know it's possible to use an IIF statement in the Word document merge field to change it to Yes/No.  

But when I tried this
{IF {MERGEFIELD "ReviewActioned"} = "True"  "Yes" "No" }

When I merge it writes
ReviewActioned

What have I done wrong?
LudiqueAsked:
Who is Participating?
 
GRayLConnect With a Mentor Commented:
use:

Format(ReviewActioned,"Yes/No")

assuming ReviewActioned contains the values -1 or 0 (True or False)
0
 
GRayLCommented:
In reality, you should export a query to Word rather than the table, in which the field ReviewActioned is replaced by the Format() function above.
0
 
GrahamSkanRetiredCommented:
It's hard to guess what is wrong. I thought you had this working a while ago. I trust that you gave entered the {} pairs with Ctrl+F9 or as a part of entering the field.
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
GrahamSkanRetiredCommented:
Should be: "...I trust that you have..."
0
 
LudiqueAuthor Commented:
Thank you.
0
 
aikimarkCommented:
What do you mean by 'export'?

I concur with the other experts that you should use a query to format the table data to better suit your needs.
0
 
GRayLCommented:
Thanks, glad to help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.