Display Yes/No field as "YES" or "NO"

[CutAndPaste]

I've got a table with a Yes\No Field. When I base a query on this field I get either a -1 /0 or a checkbox displayed in the query.

I want to display this data on a report but the usual trick of formatting the checkbox field on the report to display the text won't work as the records source for the report and the field value is generatede on the fly).

How can I show the text based Yes No in the report?

Cheers,
Simon

 

[GumbyD]

In the control source of your field on the report put:

=IIf([Your Field Name]=-1,"Yes","No")

GumbyD

 

[namliam]

=IIf([Your Field Name]=True,"Yes","No")

Same but a little easier

or maybe change the field on the report to a combo
true yes
false no

First column invisible...

Regards

 

[dcx693]

If you have a text control on your report, can you not simply set the controlsource for your field and change the Format in the properties sheet to "Yes/No" ?

 

[Rich]

=IIf([Your Field Name]=True,"Yes","No")

Same but a little easier

or maybe change the field on the report to a combo
true yes
false no

First column invisible...

Regards

=Iif([YourField],"Yes","No")
Same but even easier, although the textbox is the easiest

 

[namliam]

LOLZ

Right you are rich, what was i thinking?

Regards