yes/no = true false when merged

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I am trying to merge an access quary to a word document. The fields with the
check box come up as true/false. how do I get it to show yes/no.
 
I am trying to merge an access quary to a word document.  The fields with the
check box come up as true/false.  how do I get it to show yes/no.  
Click to expand...

as a checkbox or as text? You convert it to "Yes" or "No" with an
expression.

IIF([MyField]=True,"Yes","No")
 
<[email protected]> skrev i meddelelsen
I am trying to merge an access quary to a word document. The fields with
the
check box come up as true/false. how do I get it to show yes/no.
Click to expand...

as a checkbox or as text? You convert it to "Yes" or "No" with an
expression.

IIF([MyField]=True,"Yes","No")
 
Back
Top