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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

yes/no field format 1
yes/no again 3
adding yes/no field 2
Rename fields in Union query? 5
Access MS access forms list box problems 1
Displaying Yes or No rather than 0 or 1 1
IN Clause using multi-select form parameter 6
Using a Yes/No field to trigger a calculation in another field - J 3

Back
Top