|
| 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
May 6th, 2006, 09:25 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
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
May 6th, 2006, 09:40 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
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
May 7th, 2006, 02:02 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
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
May 7th, 2006, 02:05 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
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
May 7th, 2006, 02:11 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
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 |
Linear Mode
