Solved

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

Posted on 2008-06-17
7
623 Views
Last Modified: 2012-05-05
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?
0
Comment
Question by:Ludique
7 Comments
 
LVL 44

Accepted Solution

by:
GRayL earned 500 total points
ID: 21805975
use:

Format(ReviewActioned,"Yes/No")

assuming ReviewActioned contains the values -1 or 0 (True or False)
0
 
LVL 44

Expert Comment

by:GRayL
ID: 21805988
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
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 21806098
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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 76

Expert Comment

by:GrahamSkan
ID: 21806117
Should be: "...I trust that you have..."
0
 

Author Closing Comment

by:Ludique
ID: 31468083
Thank you.
0
 
LVL 45

Expert Comment

by:aikimark
ID: 21806241
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
 
LVL 44

Expert Comment

by:GRayL
ID: 21806394
Thanks, glad to help
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now