Convert Yes-No Results on Report

[George]

My report is based off my form and some of the fields are the results
of a Yes or No Combo box selection. When I add the field to the report and
open it, it doesn't display Yes or No it displays a Zero or Minus One. How do
I convert the number back to text ?

Thanks

 

[Golfinray]

ACCESS records yes' as -1 and no's as 0 (zero). You probably want to go to
the query your form is based on and start a new column and type:
Myfield:IIF([myyesnocolumnname]=0,"no","yes")
That will convert all the numbers to yes/no's

 

[fredg]

My report is based off my form and some of the fields are the results
of a Yes or No Combo box selection. When I add the field to the report and
open it, it doesn't display Yes or No it displays a Zero or Minus One. How do
I convert the number back to text ?

Thanks

There is more than one way. Here is a simple one.

Set the Format property of the control on the report to:
;"Yes";"No";

 

[Kai]

Thanks a million, KISS - Keep It Simple Stupid - that would be me, I always
make things more complicated than they need to be.
Kai