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

BlingGirl

New member
Local time
Today, 09:51
Joined
Apr 11, 2020
Messages
19
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?
 
select Format(myField, "Yes/No") from myTable
union all
select Format(myField2, "Yes/No") from myTable2
 

Users who are viewing this thread

Back
Top Bottom