Record Selection Problem

[brooksdotnet]

I've got a Parameter called {?Action}. The user may choose not to set that parameter - so it will get a value of "" if the user doesn't give it a value.

The Action field in the database may be NULL, "", or a value. My record selection formula works when the Action field is not NULL or "", but it doesn't work otherwise

Here's my Record Selection Formula:

IIF(Len(Trim({?Action})) > 0, {Action} = {?Action},  ({Action} <> '' OR {Action} = '' OR IsNull({Action})))

This will return all rows where there is some kind of value in the Action field but will not return any NULL or '' values. Ugh.

Any help?

Thanks!