iif wont evaluate

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Access Idiot - 16 Dec 2005 18:22 GMT

Hi, can't understand why this wont work:
=IIf(Not [dtmDateClosed] Is Null,[dtmdateclosed],"On Order")
I should show the dtmdateclosed value if it isnt Null, and the Words "On
order" if not.

Todd

Reply to this Message

SusanV - 16 Dec 2005 18:30 GMT

Try:
=IIf(Not IsNull([dtmDateClosed]),[dtmdateclosed],"On Order")

Signature

hth,
SusanV

> Hi, can't understand why this wont work:
> =IIf(Not [dtmDateClosed] Is Null,[dtmdateclosed],"On Order")
> I should show the dtmdateclosed value if it isnt Null, and the Words "On
> order" if not.
>
> Todd

Reply to this Message

Access Idiot - 16 Dec 2005 18:42 GMT

No Change.
It might be worth mentioning this is in a subform. Although the subform is
based on a query, and the field dtmDateClosed is a field in that query.

Todd

> Try:
> =IIf(Not IsNull([dtmDateClosed]),[dtmdateclosed],"On Order")
[quoted text clipped - 4 lines]
> >
> > Todd

Reply to this Message

Marshall Barton - 16 Dec 2005 19:59 GMT

>Hi, can't understand why this wont work:
>=IIf(Not [dtmDateClosed] Is Null,[dtmdateclosed],"On Order")
>I should show the dtmdateclosed value if it isnt Null, and the Words "On
>order" if not.

"won't work" isn't very descriptive of what is happening.
However, I'll make a guess the problem is caused by the text
box being named the same as the field. If so, just change
the name to something else such as txtdtmDateClosed.

Signature

Marsh
MVP [MS Access]

Reply to this Message