yes/no field and forms

  • Thread starter Thread starter MSD
  • Start date Start date
M

MSD

I'm trying to display a yes/no field in a multi-select list box on a form.
If the yes/no field comes from a query where it appears as a checkbox, it
displays as a checkbox in my multi-select list box.

However, if the yes/no field comes from a union query, where it appears as
'0' or '-1', it display as '0' or '-1' in my multi-select list box. I want
it to appear as a checkbox.

What can I do if the source of my multi-select list box is a union query?

Thanks,

Emma
 
Why a multi-select list box? The values in a union query are not updateable.
You state "I'm trying to display a yes/no field in a multi-select list box"
then you state "I want it to appear as a checkbox". These are somewhat
mutually exclusive.
 
Back
Top