If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Convert Values to Checkboxes in Table
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. |
#2
|
|||
|
|||
Convert Values to Checkboxes in Table
-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. -- Ken Snell MS ACCESS MVP "Petra" wrote in message ... 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. |
#3
|
|||
|
|||
Convert Values to Checkboxes in Table
On Sat, 6 May 2006 13:25:01 -0700, Petra
wrote: 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] |
#4
|
|||
|
|||
Convert Values to Checkboxes in Table
Thank you Ken...
"Ken Snell (MVP)" wrote: -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. -- Ken Snell MS ACCESS MVP "Petra" wrote in message ... 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. |
#5
|
|||
|
|||
Convert Values to Checkboxes in Table
Thank you John. Your advice is very successful. Much appreciated.
"John Vinson" wrote: On Sat, 6 May 2006 13:25:01 -0700, Petra wrote: 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] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need to Improve Code Copying/Pasting Between Workbooks | David | General Discussion | 1 | January 6th, 2006 03:56 AM |
Add New Field to DB | Karen | Database Design | 7 | October 19th, 2005 08:03 PM |
Formula to Sum values in word table | Craig | Mailmerge | 1 | August 29th, 2005 06:19 PM |
Manual line break spaces on TOC or Table of tables | Eric | Page Layout | 9 | October 29th, 2004 04:42 PM |
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. | HDW | Database Design | 3 | October 16th, 2004 03:42 AM |