469,326 Members | 1,415 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,326 developers. It's quick & easy.

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

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?

Oct 11 '10 #1
2 3739
32,181 Expert Mod 16PB
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.
Oct 11 '10 #2
3,080 Expert 2GB
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".

Oct 12 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Lauchlan M | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.