Changing a 0 to No

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

Guest

I get a report that uses 0 and 1 for No and Yes how can I make that show in
the report Yes and No and not 0 and 1
 
I get a report that uses 0 and 1 for No and Yes how can I make that show in
the report Yes and No and not 0 and 1
Click to expand...

Are you sure the Yes value is 1 (and not -1 which is the normal Access
value for True or Yes?)
Use a text control.
Set the Control source to the Field

If Yes = 1
Set the control's Format property to:
"Yes";;"No"

If the Yes value is actually -1, then
set the Format property to:
;"Yes";"No"

See Access help
Format property + Number and Currency datatype
 
I am not sure that I worded this right. I link to a database table on our
server and users have to enter yes or no in one of the fileds. But when I
export the data the field has 0 and 1 in them. 0=No and 1=Yes. I am trying to
run a report against that data but have the report out replace the 0 to No
and the 1 to Yes.
 
I am not sure that I worded this right. I link to a database table on our
server and users have to enter yes or no in one of the fileds. But when I
export the data the field has 0 and 1 in them. 0=No and 1=Yes. I am trying to
run a report against that data but have the report out replace the 0 to No
and the 1 to Yes.
Click to expand...

I believe I answered your question!
IN THE REPORT set the control's Format property to:
"Yes";;"No"
 
Back
Top