This has to do with Word, VFP and Access. I am trying to create a mailmerge document in Word that includes a logical field, (or as in Access - a Yes/No field). When the data is merged, the result displays as a "0" for No and "-1" for Yes in the document. It happens for the my client's Access table. I don't want to have to make them use a VFP table if I don't have to. How do I format this field in my Word document to display the data correctly as a Yes and No. Do I change something in Access table or is there some field codes I could use in Word.
If you could, please give me an example if it involves "Field Codes". Any help will be appreciated. Thanks.
Elgin