[AccessD] Setting form filter string

Max Wanadoo max.wanadoo at gmail.com
Wed Apr 8 12:02:04 CDT 2009


What is the error being reported?
Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
Sent: 08 April 2009 15:58
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




More information about the AccessD mailing list