Expressing True/False (-1/0) as Yes or No Literals on Report Output

[JHMarshIII]

I can't seem to figure out how to convert the stored true/false values in a table as Yes or No in the output of a report. Instead I get -1 for yes and 0 for no. Any ideas? TIA

 

[Rich]

Set the Format to Yes/No

 

[golgo1]

little trick: create an unbound textbox (Tbox1) place it where the yes/no should go. Make the bound textbox visible=false. in the FORMAT event of DETAIL, enter code that will make Tbox1 = Yes if true or vice versa. the invisible control can still be referenced, but user sees the unbound Tbox1.

 

[JHMarshIII]

Rich said: <set the format to Yes/No>

Rich may I ask the format of what? the table field or the report control? Both? I think I have tried the table approach but have still gotten -1 for yes and 0 for no on the report output.

golgo1 said <in the FORMAT event of DETAIL, enter code that will make Tbox1 = Yes if true or vice versa.>

golgo1, I'm a code newbie, would you provide an expamle of the expession I would use?

TIA John

 

[Rich]

Add an unbound text box to the report, set the format to Yes/No, set its control source to the yes/no field.
HTH