Filter by Form problem

  • Thread starter Thread starter Dave Eliot
  • Start date Start date
D

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.
 
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.
 
Rick said:
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.
 
Back
Top