Changing a 0 to No

[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

 

[fredg]

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

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

 

[Guest]

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.

 

[fredg]

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 believe I answered your question!
IN THE REPORT set the control's Format property to:
"Yes";;"No"

 

[Guest]

Thanks... its still not working... but I will try some more....