When querying a db where some original input fields were check boxes and
were inserted into the db as a binary (yes/no, 1/0, on/off), is the only way
to display a check box on the query page, either checked or unchecked, to
create a form and add an insert field? If so, I'm having trouble with the
In the database field you can set the value to anything you want,
however you will need to test for the value to properly
set the checkboxes on the form to be checked or unchecked.
Example:
CheckBoxField: Value could be "AGREE" or DISAGREE"
on the Form:
checked>
>>> [EMAIL PROTECTED] 11/01/02 1
The way I've always done this is this:
On the form page:
On the processing page:
..the benefit of this approach is that, should the checkbox be checked
on the form page, form.ThisBox is passed to the processing page with a
value of "1". When it is _not_ checked, it is not passed to the
Oh yeah, I may have slightly misunderstood the last question, so to add:
The way to do this on the form page is this:
..since it is a boolean we are using as a value, in the IIF, "1"
evaluates to "true", and "0" to false. Thus only "1"s make the checkbox
be checked.
Randell B Adkins wrote:
Boxes - another NUG question
Oh yeah, I may have slightly misunderstood the last question, so to add:
The way to do this on the form page is this:
.since it is a boolean we are using as a value, in the IIF, "1"
evaluates to "true", and "0" to false. Thus only &quo
5 matches
Mail list logo
