Yes/No/Null number Combobox error "value you entered isn't valid for this field"

[Emily Lisker]

I am using Yes/No/Null number combo boxes per Allen Browne's instructions (http://allenbrowne.com/NoYesNo.html). My validation rule is:

"Is Null Or 0 Or -1"

I copied Allen Browne's lookup box as shown below:
Display Control: Combo box
Row Source Type: Value list
Row Source: -1;"Yes";O;"No"
Bound Column: 1
Column Count: 2
Column Heads: No
Column Widths: 0"
List Rows: 8
List Width: Auto
Limit to List: Yes

When I select Yes from the drop down combo box, it works fine. However, when I select No I get the error, "The value you entered isn't valid for this field." Can you please tell me how to fix this?

Thanks,
Emily

[NeoPa]

Emily, I suggest if you have a question you'd like to ask here then posting the details of the question would be a good start. Expecting people to hunt around to try to determine what your question is is probably not the best way to proceed.

Allen Browne's stuff is generally highly respected here, but to expect full knowledge of it all, or even for us to have to go and look it up, is not too helpful.

I need context to understand this, and currently that context is missing.

[nico5038]

Looks to me you should change the "O" into a 0 (Zero) in:

Row Source: -1;"Yes";O;"No"

It looks like you've assigned the letter "O" instead of 0 (zero) "No".

Nic;o)