Convert Yes-No Results on Report

  • Thread starter Thread starter George
  • Start date Start date
G

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
 
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
 
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
Click to expand...

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

Set the Format property of the control on the report to:
;"Yes";"No";
 
Thanks a million, KISS - Keep It Simple Stupid - that would be me:), I always
make things more complicated than they need to be. :)
Kai
 
Back
Top