The default HTML checkbox always submits a value of 'on' when the checkbox is checked. This property allows you to specify a different value to be associated with the checked state of the checkbox.
The Checkbox can be linked to a database field of the "Text" type which stores "Yes" and "No" values. To do that set the DataType property to "Text", and enter "Yes" for the Checked Value Property and "No" for the Unchecked Value property obligatory in double quotes.
The following are the possible applications:
Data Type | Checked Value | Unchecked Value |
---|---|---|
Text | "Y" | "N" |
Integer | 1 | 0 |
Boolean | True | False |