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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form filter combo box choices are Is Null/Is Not Null 3
Filter a list containing null values 3
Filter by Form problem 2
Filter by form in linked table database 2
Query by Form shows Null or Is Not Null 3
drop down based on query but also need a blank as an option 4
Form filter combo box choices are Is Null/Is Not Null 13
Form Filter will not delete 2

Back
Top