Heenan, Lambert
Lambert.Heenan at aiuholdings.com
Wed Apr 8 10:20:11 CDT 2009
I've never tried to do it that way in the past either, Charlotte. I've always set my filter string and then set FilterOn to True/False as appropriate. I was just curious to see what would happen in the light of this thread. Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Wednesday, April 08, 2009 11:12 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Setting form filter string 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com