check box display 0/-1

W

wirtgen

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

James McNellis

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

Van T. Dinh

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