I have a big problem that I hope someone could help me with. I have a form that I use to Filter all my records. As soon as I surpass the 1,000th record the DATE field says Is Null Is Not Null when I use Filter by Form

This happens every year when I get to the 1,000th record. On a normal day I can use filter by form and select a Date in the field and Access will come back with all of the records from that date. As soon as I hit 1,001 I can Filter any field except the DATE field. I know this because all I have to do is delete a few records and Null error goes away. I'm not a programmer but they're has to be a logical answer for this.

Thanks for any help,

Troy in NJ.