Max Wanadoo
max.wanadoo at gmail.com
Wed Apr 8 12:01:01 CDT 2009
Not in my Access version you don't ! Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: 08 April 2009 16:09 To: Access Developers discussion and problem solving Subject: Re: [AccessD] Setting form filter string It's necessary, weird or not. You have to set the filteron property to false before you can change the filter. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele Sent: Tuesday, April 07, 2009 7:31 PM To: accessd at databaseadvisors.com Subject: [AccessD] Setting form filter string Hello All: 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 -- 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