By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,635 Members | 911 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,635 IT Pros & Developers. It's quick & easy.

Filter By Form

P: n/a
When I use the standard "Filter By Form" button, each control is usually a
combo box with the preset choices of "Is Null" or "Is Not Null". But
sometimes a control will be a combo box with the preset choices of every
unique value that exists for that control in the unfiltered record source.
Does anyone know what circumstance lead to these 2 different scenarios?
TIA,
Fred Zuckerman
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Fred Zuckerman wrote:
When I use the standard "Filter By Form" button, each control is usually a
combo box with the preset choices of "Is Null" or "Is Not Null". But
sometimes a control will be a combo box with the preset choices of every
unique value that exists for that control in the unfiltered record source.
Does anyone know what circumstance lead to these 2 different scenarios?
TIA,
Fred Zuckerman

Funny you should ask, because I just had that problem today in A2003.

You can try two fixes. One is to change the maximum number of records to
display for any QBF field (default is 1000). The other is to change the
value of the FilterLookup property for the combo box to "Always".

These options are described in Help for the FilterLookup property.

(I just had a case where changing the default maximum number of records
didn't work, but changing the FilterLookup property did).

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.