[AccessD] Setting form filter string

Would it take this?

Dim str as string
Str = ""
Me.filter = str
Me.filteron = false

Max


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