Checkbox values - 'Yes' or 'On'?

When you use checkboxes on Edit/Add pages ASPRunner always puts 0 or 1 into database field. This means you need to use database type that accepts integer values. This would Yes/No field in MS Access or TINYINT field in SQL Server.
Using text fields for this purpose is not good.

Thanks for that, works a treat...
Just one final question - is it possible to have a check box as a required field? Something along the lines of "I have read the terms and conditions and wish to proceed", that sort of thing.
I've tried playing around with the code but with no luck.
Cheers,
Adam

Hi,
you can use this code snippet. Replace fieldname by your check box field name.

<form name=editform onSubmit="if

Hi,
This is building on from the previous answer.
I also have a check box I wish to make sure is ticked, the only problem is I also wish to validate the fields, thus I have two actions for the 1 on submit button
"if

(!document.forms.editform.fieldname.checked)

{ alert('You have to agree with ...'); return false; }" >
and
" return validate();">
How do I include both of these in the one action (if this is at all possible)
Many thanks
Julie

Julie,
you need to put this Javascript code into the very beginning of validate() function that can be found in include/validate.htm file. Make sure you return false if validation not passed.