form text box filter issue

A

AccessMan

I have a text box on a form in a 2007 database that does not behave as
expected when filtering by form. Only the choices Is Null and Is Not Null
are available to me, rather than the entire list of values, despite the fact
that there are fewer records than the 10,000 record limit set in Access
Options for list display. Is there some other control on this behavior?

Thanks!
 
A

AccessMan

AccessMan said:
I have a text box on a form in a 2007 database that does not behave as
expected when filtering by form. Only the choices Is Null and Is Not Null
are available to me, rather than the entire list of values, despite the fact
that there are fewer records than the 10,000 record limit set in Access
Options for list display. Is there some other control on this behavior?

Thanks!
Click to expand...
 
A

AccessMan

I'm surprised that nobody has responded yet with a suggestion as to what is
causing this problem. I know it's not a particularly intriguing topic, but I
do hope to get it resolved. Has anybody else seen this?

Thanks!
 

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

Filter by form in linked table database 2
Form filter combo box choices are Is Null/Is Not Null 3
text box filter by form 1
Form Objects Disappear When Filter Returns No Records 4
Continuous Form - Populate unbounded field 1
Filter by form Listing 1
Check box to control editablility of text box and return all recor 1
Need all records on continuous form to meet a criteria 2

Top