Filter by Form problem

[Dave Eliot]

I have a simple table with an input form. One of the fields is called
"title." For years I've searched using Filter by Form and entering a
title. Now, today, with no change in the design of the table or form,
when I use Filter by Form my only choices in the title field are "Is
Null" or "Is Not Null." Anyone have a clue as to what could have
happened? Or how to fix it?

Thanks.

 

[Rick Brandt]

I have a simple table with an input form. One of the fields is called
"title." For years I've searched using Filter by Form and entering a
title. Now, today, with no change in the design of the table or form,
when I use Filter by Form my only choices in the title field are "Is
Null" or "Is Not Null." Anyone have a clue as to what could have
happened? Or how to fix it?

Thanks.

If the number of distinct values is too high, Access will revert to Null
and Is Null. The limit is a setting in options I believe.

 

[Dave Eliot]

If the number of distinct values is too high, Access will revert to Null
and Is Null. The limit is a setting in options I believe.

Thanks so much, Rick. I found it in Options, changed it, and now all is
well.
Thanks again.