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

BlingGirl

New member
Local time
Today, 15:56
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?
 

tvanstiphout

Active member
Local time
Today, 15:56
Joined
Jan 22, 2016
Messages
161
select Format(myField, "Yes/No") from myTable
union all
select Format(myField2, "Yes/No") from myTable2
 

Users who are viewing this thread

Top Bottom