Yes/No Field doesn't update in edit (1 Viewer)

[suzeg]

I am opening a subform in edit mode. The form has a Yes/No field that when the form opens shows 0 (Which I know means False, I would like it to show No). Also, I cannot change that value. Even if I type in -1, it does not save to the record.
Any help greatly appreciated.

 

[Pat Hartman]

Change the format of the control (Format on the Format tab of the properties dialog). I like to use checkboxes for yes/no data types. To do this, delete the text box and add a checkbox. Bind the checkbox to the Yes/No field.

 

[suzeg]

OMG - So easy - I never looked at the format options. Duh. I did change it to a check box. Wonderful. Thank you. This forum is so helpful!!