Yes\No;"*" Value list

[zweet18]

Need help i have a value list of

Row source type: Value List
Row source:
-1;"Yes"
0;"No"
"*";"Yes/no"

everything is fine except for yes\no value

error said

the expression typed incorrectly or too complex to evaluated etc..

is there a way that i can use * or all or what is the best thing to do to
add yes\no in value list just to show if they want all the record

Thanks in advance and appreciated a lot.....c",)

 

[Van T. Dinh]

(see the Access General newsgroup).

Please do not multi-post the same question. Most regular respondents read a
large number of newsgroups and don't want to see the same question again &
again.

 

[Duane Hookom]

I expect the field type is numeric or yes/no. You can't store "*" in any of
these field types. It is also a bit difficult to query for "*" values in a
field since it is a wildcard.