I'm putting together a survey for research purposes. Some of my questions require multiple answers, and I've used check boxes. However when data is entered into the database I can't tell the difference between a person not ticking a check box because the answer is 'No' and a person not ticking a check box because they've missed the question out. Can anyone give me a way of sorting this - it is quite important in terms of data reliability.

if you use radio buttons instead you can have a yes or no response. Place two radio buttons on the form but ensure they have the same name but the value when selected is defferent.

This will return a null or empty value if they have not selected anything or yes or no if they have selected.

To make them select at least one you need to add some field validation.

If you need to validate reply to this post and I will copy some code for you to do so.

Response.write("The best line of code you can ever use"

Vince
VBScript | ASP | HTML | SQL | Oracle | Hosting

Hi Vince,

Thanks for your reply. Yes, I had thought of using radio buttons, and indeed have done in some parts of the survey, but for the multi-answer questions they're not a very elegant solution. I'd still like to know if there is a way round the check box dilemma.

Susie