Disabling Databound Checkbox if its value in table is null

M

mandarkn

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
 
W

Wayne-in-Manchester

If IsNull([FIELDNAME]) Then
'set fields .visible = false
ELSE
'set fields .visible = true
End If

Hope this helps
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Table Preferred width is changed when pasting 1
Pls Help - Checkbox not updateable 2
Form filter combo box choices are Is Null/Is Not Null 3
Checkbox values at run time 5
Combobox controled by checkbox 2
How to make checkboxes add records to junction table 4
Access checkbox and SQL Server bit 1
Checkbox to a query 11

Top