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
|
|||
|
|||
yes/no value lists
Hello, I have a table that has the user answer yes/no to several questions.
I'm using a combo box w/value list to do this for each of the fields. When I test entering data into the table and select one of the fields that has the yes/no value list, all of the fields that have the value list appear in the row as "no" even though I haven't selected them and the default value isn't set to no or yes. I need for the fields to appear blank until the user selects yes or no. Can I do this in the table without setting up smaller tables for each field??? Thanks for your help!! -- DM |
#2
|
|||
|
|||
yes/no value lists
Are you using a text datatype to store the Yes/No or are you using a datatype
of Yes/No? "DM" wrote: Hello, I have a table that has the user answer yes/no to several questions. I'm using a combo box w/value list to do this for each of the fields. When I test entering data into the table and select one of the fields that has the yes/no value list, all of the fields that have the value list appear in the row as "no" even though I haven't selected them and the default value isn't set to no or yes. I need for the fields to appear blank until the user selects yes or no. Can I do this in the table without setting up smaller tables for each field??? Thanks for your help!! -- DM |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Add New Field to DB | Karen | Database Design | 7 | October 19th, 2005 08:03 PM |
Adding Contacts to and managing Distribution Lists in Outlook 2003 | I | General Discussion | 1 | June 15th, 2005 10:32 PM |
Need Help on "Yes/No" Query | jcrowe | Running & Setting Up Queries | 4 | November 9th, 2004 09:39 PM |
Help with searching/replacing numbered lists | Jason L | Page Layout | 3 | November 1st, 2004 07:37 PM |
Yes/No boxes in forms | Stephen Glynn | New Users | 14 | May 30th, 2004 07:25 PM |