Using A Checkbox For A Text Field

[LanieB]

Hello Ladies and Gents!



I'm not sure if this is possible. I don't want to use a Yes/No field in the table. I would prefer to use a text field, so it can filter the 'answer' into another table.
My question is, is there anyway to use a checkbox in a form, but you define what the Check and Uncheck enter into a table? Aka. If it's checked, it places a yes in the table and if unchecked it places a No in the table. I tried to use yes/no fields but that wouldn't filter right with my form and subform.

Please let me know your thoughts!
Thank you!

Lanie

[Rawb]

Yes, but you'll need to use custom VBA coding to accomplish it.

1. Create an Unbound checkbox with the appropriate default values, etc.
2. Then edit its After Update Event with an If statement similar to the following:

  If Me!MyCheckbox = True Then
    Me!FieldToChange = "My new Value if True"
  Else
    Me!FieldToChange = "My new Value if False"
  End If