Check box resulting value?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi..any help appreciated...

When checked, checkboxes on my form "translate" to another check box on the
associated field in a table. How can I change this so that when a box is
checked on the form, the field value is "YES"?

Thanks
 
why?
How you carry data and how you present data to users are two different
things. I would recommend you just use something like this when you want the
user to see it:
Iif(MyField, "Yes", "No")

If you insist on making this mistake, you will need to unbind your field
from the check box and change the data type of the field to text.
Then you will need to create a hidden text box and bind it to the field.
Then in the After Update event of the check box:

Me.MyUselessTextbox = Iif(Me.MyCheckBox, "Yes", "No")
 
Hmm..am not sure I follow.

User will only see form. They'll check the box or not check the box.
In the table (which only I will see), in the column (field) associated with
the checkbox, there is a checkbox. Since I will want to do some type of
analyses on the data, I'd like to know whether the table can show a "yes" or
a "1" when the form checkbox is checked.

Sorry for not being clear.
 
exactly, That is what Iif(MyField, "Yes", "No") is for.

If MyField is 0 it will return "No"
If it is -1 it will return "Yes"
 
Back
Top