yes/no data type

D

dlb1228

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?
 
R

Rick B

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.
 
D

dlb1228

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
 
R

Rick B

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.
 
R

Rick B

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.
 
Top