Disable automatic expression checking?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frankenbox - 09 Mar 2006 17:09 GMT

I am trying to create a search criteria for a query which selects for entries
by a specific user in a database, or if no-one is specified returns all user
entries.

The following criteria performed the task to my satisfaction:

IIf(IsNull[Which User?],"*",[Which User?])

However upon saving and closing the help feature decided that I needed ""
marks throughout, so that when I opened it to run again the following
expression was in place.

IIf("IsNull[Which User?]","*",[Which User?])

This expression does not work (nor do my attemts at working around the
*helpful* feature)...

How do I prevent Access from treating my like an Idiot and trying to provide
useless assistance?

Reply to this Message

Douglas J Steele - 09 Mar 2006 17:36 GMT

The first expression was wrong: you didn't have the parentheses for the
IsNull function:

IIf(IsNull([Which User?]),"*",[Which User?])

If it worked the first time, it was just a coincidence.

Better, though, might be:

Nz([WhichUser?], "*")

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> I am trying to create a search criteria for a query which selects for entries
> by a specific user in a database, or if no-one is specified returns all user
[quoted text clipped - 15 lines]
> How do I prevent Access from treating my like an Idiot and trying to provide
> useless assistance?

Reply to this Message

Frankenbox - 09 Mar 2006 17:52 GMT

Thanks!

> The first expression was wrong: you didn't have the parentheses for the
> IsNull function:
[quoted text clipped - 29 lines]
> provide
> > useless assistance?

Reply to this Message