Need yes/no not true/false in Word

G

Guest

I am merging access data into a word document. I have a yes/no field merged
into my document. When I merge that field into word, it reads true or false
instead of yes or no. How do I get it to read yes or no instead of true or
false in my word document? In my field properties, it says yes/no in the
format and the display control in text box. Help?!?!?!
 
D

David Seeto via AccessMonster.com

The underying value in the database is True/False - if you want it to
appear as Yes/No when merging with Word, create a query with a field that
maps the value to what you want (Yes/No) eg.

Answer_YES_NO: iif([Answer], "Yes", "No")
 

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

yes/no = true false when merged 3
Yes/No Data Type format when exported to a spreadsheet 3
Export Yes/No Fields to MS Word 2007 - check box is missing 5
YES/NO Field 2
Import an Excel yes/no field 1
How to call open a Word doc with links from within Access 2003 1
An Access table linked to Word 1
Exporting data from checkboxes 5

Top