Is there a limit to the number of records Access can query back in the filter by form option? When I use this option on one particular date field in my form I get 2 values to select from 'Is Null', 'Is Not Null', instead of a list of dates. If I delete half my records I get a list of dates as expected. Could it be that I have corrupt data?

Thanks in advance.