Mailmerge to Word issue

[postmanphat]

Hi,

My data source - an Access query - has various fields that in the database are presented as Checkboxes, but are obviously stored as a 1 or 0 in the table. How do I portray these data values as checkboxes on my merged Word doc? They just come out as 1's and 0's which obviously isn't very useful.

Many thanks in advance,

Dave

 

[Remou]

The easiest solution is probably to format the fields in a query and use that for the mailmerge:

Format([YN],"Yes/No")

 

[MikeC14081972]

Have an expression in your query

YesNo: IIF([NameofField]=-1,"Yes","No")

use the output of this field in the Mail Merge instead of the source field.