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
|
|||
|
|||
Disabling Databound Checkbox if its value in table is null
Hi,
I have created a table which represents a simple Questionaire. The Questions and various options (answers) form columns and there are additional bit columns which represent whether the respective option is selected or deselected. One problem I am facing is that my questions can have varied number of options like some may have 4 options, some may have 5, and others may have 6. The form is bound to the table, options are represented by lables and bit columns by checkboxes. The form display all records from the Questionaire at a time. Now I do not want to display the checkboxes and respective Option when their value is null in the table. Is this possible? If yes How? Thanks & Regards, Mandar |
#2
|
|||
|
|||
Disabling Databound Checkbox if its value in table is null
If IsNull([FIELDNAME]) Then
'set fields .visible = false ELSE 'set fields .visible = true End If Hope this helps " wrote: Hi, I have created a table which represents a simple Questionaire. The Questions and various options (answers) form columns and there are additional bit columns which represent whether the respective option is selected or deselected. One problem I am facing is that my questions can have varied number of options like some may have 4 options, some may have 5, and others may have 6. The form is bound to the table, options are represented by lables and bit columns by checkboxes. The form display all records from the Questionaire at a time. Now I do not want to display the checkboxes and respective Option when their value is null in the table. Is this possible? If yes How? Thanks & Regards, Mandar |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need to simplify Switch() | Nick X | Setting Up & Running Reports | 11 | January 26th, 2006 04:54 PM |
Convert Count(Case()) SQL Server Query to Access | [email protected] | Running & Setting Up Queries | 3 | November 17th, 2005 11:06 PM |
Add New Field to DB | Karen | Database Design | 7 | October 19th, 2005 08:03 PM |
Table Design | A. Williams | Database Design | 3 | April 29th, 2005 07:02 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 |