changing the value of a bound test box

[Guest]

I have a form that previously contained check boxes; I changed them to text
boxes so that reports generated from the underlying table had meaningful data
rather than "0" or "1". I added a label and am trying to change the value of
the field in the table bound to the text box using the (Click) event. It
doesn't work! What am I doing wrong?

 

[RBear3]

Why did you change this from a checkbox? The form has nothing to do with
your report. On your report, you can print the checkbox or not to indicate
a true/false situation. Or, you can print the literal "Yes" for -1 of "No"
for 0. You can do anything you want on the report. If the field is still a
Yes/No field in your table, then I would us a checkbox on my forms (if that
works well for you). It has nothing to do with your reports.

 

[Guest]

Your comments are well taken; I'm new at programming, so I make silly mistakes.
Regardless, how do I accomplish this for future reference?

 

[RBear3]

No problem. Is your field in the table still a Boolean type field (Yes/No)?

If so, go ahead and put your checkboxes back on the form and bind them to
the field in the table.

As far as your report, what do you want to show? Do you want the word "Yes"
to print if the field is true? If so, build an unbound control on your
report and put something like the following in it...

=IIf([YourFieldName],"Yes","No")

 

[Marshall Barton]

Or just set the text box's Format property to Yes/No or use
a custom format. E.g.
;"Completed";"Still not done";"Who knows"