Convert Values to Checkboxes in Table

[Petra]

I added yes/no bit fields to an existing table and the fields display values
of -1 and 0 instead of the checkboxes. How can I convert these values to
checkboxes? Any help is appreciated.

 

[Ken Snell \(MVP\)]

-1 = true, 0 = false (or yes / no). That is how the data are stored; the
checkbox is just a visible representation to show the values. You will need
to use a checkbox control on the form or report.

 

[John Vinson]

I added yes/no bit fields to an existing table and the fields display values
of -1 and 0 instead of the checkboxes. How can I convert these values to
checkboxes? Any help is appreciated.

Open the Table in design view; select this field. On the properties
tab in the lower left select the Lookup tab. Change the "display as"
line from Checkbox to Textbox.

John W. Vinson[MVP]

 

[Petra]

Thank you Ken...

-1 = true, 0 = false (or yes / no). That is how the data are stored; the
checkbox is just a visible representation to show the values. You will need
to use a checkbox control on the form or report.

 

[Petra]

Thank you John. Your advice is very successful. Much appreciated.