Filter by Form (Max number of values)

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

Guest

If I'm working with a very large table and want to use the Filter by Form
feature to filter on a field, is there a maximum number of values Access will
display in the drop-down list when filtering on a field using this feature?
Thanks.
 
Yes, this number can be set by going to Tools|Options|Edit/Find tab. The
value is "Don't display lists where more than this number of records read:".
There are also 3 checkboxes that will affect what is displayed. The number
is the total number of records, not the number of unique values for the
field. You can make another adjustment in form design mode by setting the
FilterLookup (Data Tab) property for a control. This can be set to ignore
the number entered above.
 
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 13
QAT & Filter By Form 1
VBA: How can I use a string variable as autofilter criteria? 4
Multiple Filters on Continuous Form 7
Trying to filter a form by VBA 1
How to Convert EML to PST? 2
Filter by Form behaving oddly? 6
database didn't build the filter 1

Back
Top