check box display 0/-1

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

Guest

I have several check boxes in a form, when I run queries one check box
appears on the table while the others use 0 and -1. How do I get them all to
display the checked and unchecked boxes? Thanks.
 
Hello.

Open in design view the table that contains the fields you want to be check
boxes.

Select the field you want to change to a text box.

On the tabs at the bottom of the screen, select "Lookup". There is a
"Display Control" option, that, if you set it to "Check Box", will display a
check box.

Cheers--

James.
 
Open the Query in DesignView. Right-click on the Field that display 0 / -1
and select Properties .... In the LookUp tab, select CheckBox as the
Display Control.
 
Back
Top