[AccessD] Setting form filter string

Another Access 2003 foible? In Access 2002 setting the filter to "" not only removes the filter string it also automatically sets FilterOn = False.

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
Sent: Wednesday, April 08, 2009 10:58 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Setting form filter string

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>
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com