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
 
G

Guest

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

Top