IIF statement based on check box returns #error

[timmygrover]

This is my statement:

=IIf([Checkbox]=-1,"Yes","No")

It works great once I've manipulated the checkbox, but before I touch it, it returns an #Error

I don't know what value to assign in order to get a "no" if the check box hasn't been touched.



I've also tried

=IIf([Checkbox]=0 OR [Checkbox]="","No","Yes")

[pbaldy]

Try

=IIf([Checkbox]=0 OR IsNull([Checkbox]),"No","Yes")

[timmygrover]

Same result

[June7]

=Format([Checkbox],"Yes/No")


Is the Checkbox bound or are you wanting to save the textbox value to table?

[timmygrover]

No, I'm using this in an unbound table where the user fills out a few text boxes/check boxes/drop downs/etc., and then you get a certain string of text based on your input. The issue is that the checkboxes mess up my iif statements until I check/uncheck them. I can't find a way for them to function in a situation where they just need to be left unchecked.

[orange]

I'd try

=IIf([Checkbox]<>-1,"No","Yes")

[June7]

Did you mean 'unbound form' instead of 'table'?

I tested my suggestion and it worked. Returns Yes, No, or empty string; no #Error.

[timmygrover]

Yeah, June, i did mean form, and I was so busy responding to what I'm doing that i didn't try your solution! It worked! Thanks so much!