Get a Listbox to display yes/no values

[guamlet]

I have a 10 column listbox that is in a subform. The listbox is linked to a query that has mostly numeric fields, but also a few yes/no fields in the forms of checkboxes. The listbox is currently returning "-1" for a checked box (meaning "True") and "0" for an unchecked box (meaning "False"). Is there a way to get the listbox to display either "Yes" or "No" instead for these columns while leaving the other columns formatted the way they are? I'd even settle for "True" or "False"...just anything other than "-1" and "0".

Thanks!

 

[boblarson]

In the query use

MyNewFieldName:IIf([YourFieldNameHere]=-1,"Yes","No")

 

[guamlet]

Thanks! I had that at first, but put the -1 in quotes which of course didn't work so I thought I had the whole thing wrong....stupid syntax...haha