Yes No Fields not displaying properly in mail merge (1 Viewer)

[SiE]

I have created a query in Access which I use as a source for a mail merge in word. I have set the fields up in the query so that any yes no fields have the format of yes\no and that there lookup display control is text box. When I come to display my records in the merge yes no's appear as -1. Where have I gone wrong?

The only solution I have is to create a string from each yes no in the query using an iif statement. I dont really want to do this though as there are around 40 yes no fields in my query.

Any Ideas?

 

[lynsey2]

right im usualy clueless but if you have them in one place as yes/no feilds and another place as text boxes im not too sure access will like that!

//QUOTE//
any yes no fields have the format of yes\no and that there lookup display control is text box
//UNQUOTE//

 

[SiE]

By setting the display format to text box you output the field as "YES" or "NO". If you leave the field to its default settings it displays the field as a box with a tick in. Its the lookup control that I have set not the field type.

Anybody got any ideas?