Is Null/Is Not Null only options when doing a Filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I did not setup this database but I am now the one working with it. I used
to be able to filter by form and click on the drop down menu and selet any of
the names that I have entered to be my filter. Now all I get is a choice of
is: Is Null/Is Not Null

I must have changed something, but I have no clue what.

Thanks in advance.
 
You may not have changed anything. By default, Access does not display those
lists when they exceed 1000 rows.

From the Tools menu, select Options, and in the Options dialog select the
'Edit/Find' tab. The option you're looking for is labelled 'Don't display
lists where more than this number of records read'. (This description is
based on Access 2003, there may be differences in earlier versions).

Keep in mind, though, that there is a good reason for this default setting.
You may find that substantially increasing it has a negative impact on
performance.
 
Thanks, Brendon. That was exactly what I needed. I changed the setting and I
off and running again.

Thanks again,

cd
 
Back
Top