Format Yes/No in List Box Union Query (1 Viewer)

[BlingGirl]

Is there a way to format a Yes/No field in a List Box? I am populating the list box from a Union Query and it is displaying the Yes/No fields as 0 & -1. Is there a way to format it to True/False or Yes/No?

 

[tvanstiphout]

select Format(myField, "Yes/No") from myTable
union all
select Format(myField2, "Yes/No") from myTable2

 

[BlingGirl]

Thank you @tvanstiphout! It worked great!