Convert Values to Checkboxes in Table

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

Guest

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.
 
-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.
 
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.
Click to expand...

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]
 
Thank you Ken...

Ken Snell (MVP) said:
-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.
Click to expand...
 
Back
Top