[AccessD] Setting form filter string

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>
>



More information about the AccessD mailing list