Queckbox to text

[Niniel]

I need to have a check box on my form [it's a questionnaire]. The underlying
data field, however, is a text field [for a certain reason]. What I'm looking
for is a way to write a value into the database of yes or no [can be changed
to true/false, -1/0] depending on the state of the check box.

Is there a[n easy] way to do that? Maybe something along the lines of "if
checkbox = true then value for field in table x = yes"? The default value is
to be 0.

 

[Allan Murphy]

In the AfterUpdate event of your checkbox write

If checkbox=true then
text_answer="Y"
else
text_answer="N"
end if

You could use "Yes" or "No" or other suitable text.

Allan Murphy


Email: (e-mail address removed)