Turning 1 and 0 values into Yes and No

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a form with yes no buttons for people to select things. For instance,
if a person wants to send a business card they click on the business card
button on the form. I then created a report based on all of the selections
that people make. The values are all 0 and 1 on the report but I want to
make them Yes and No. Is there a way to do this in the report?

Thanks,
 
You can set the format property of your text box to display Yes or No based
on the bound numeric value.
Check Help for various options if you can't figure this out.
 
Hi,

I have a form with yes no buttons for people to select things. For instance,
if a person wants to send a business card they click on the business card
button on the form. I then created a report based on all of the selections
that people make. The values are all 0 and 1 on the report but I want to
make them Yes and No. Is there a way to do this in the report?

Thanks,
Click to expand...

Add an Unbound text control to the report.
Set it's control source to that of the Check Box field.
Set the control's Format property to:
;"Yes";"No"
 
Back
Top