sstreet
Access Demon
- Local time
- Today, 02:49
- Joined
- Dec 5, 2002
- Messages
- 50
I would like the following statement to take an entered value unless it is null. If there is no value entered, I would like to use the * operator to show everything from that field.
IIf([Forms]![SearchForm]![txtinvestment] Is Null,Like "*",[Forms]![SearchForm]![txtinvestment])
Why does this code not work?
IIf([Forms]![SearchForm]![txtinvestment] Is Null,Like "*",[Forms]![SearchForm]![txtinvestment])
Why does this code not work?