Doug Steele
dbdoug at gmail.com
Wed Apr 8 09:58:28 CDT 2009
No, I tried that as well. On Wed, Apr 8, 2009 at 1:11 AM, Max Wanadoo <max.wanadoo at gmail.com> wrote: > Would it take this? > > Dim str as string > Str = "" > Me.filter = str > Me.filteron = false > > Max > > > I discovered today that I couldn't assign the empty string to a form filter > in Access 2003: > > Me.Filter = "" > > left the filter string unchanged. I couldn't assign a Null to it, either. > Has anyone else run into this? Help doesn't say anything. The workaround > is to set Me.FilterOn to False instead, but it still seems weird. > > Doug Steele > <http://www.databaseadvisors.com> >