[AccessD] Setting form filter string

Charlotte Foust cfoust at infostatsystems.com
Wed Apr 8 10:12:17 CDT 2009


I never made that work reliably in any version, Lambert. 

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan,
Lambert
Sent: Wednesday, April 08, 2009 8:09 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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

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