yes/no data type

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have 2 queries and they both have yes/no fields in them. when i go to
datasheet view i can see the check mark in the field, but when i use a union
query to combine the two it gets rid of the check box and makes the field -1
and 0 is there a way to get this check box back?
 
You can't display the checkbox in a query. The value stored in that field
is indeed a -1 or a 0.

If you want to see the checkboxes, use a report or a form.
 
how do i get the check box to appear on the report i see under format i can
change it to yes/no but i want to see a check box
 
Use the checkbox tool in your toolbox and drag it to the report while in
design view. Then set the appropriate field value in the DATA tab.
 
Oops. You don't "drag" the control to the report, you select it, then draw
a square on your report. I'm guessing you figured that out though.
 

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 Data Type 2
Format Yes/No in Union 4
Evaluate Yes/No Field Based on User Input 7
yes/no field format 1
adding yes/no field 2
IIF Statement in Query 2
Update Query on Yes/No Field 1
Check box and make table query 1

Back
Top