Filter by Form (Max number of values)

D

djn

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.
 
W

Wayne Morgan

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.
 
Top