Turning 1 and 0 values into Yes and No

[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,

 

[Duane Hookom]

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.

 

[fredg]

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,

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"