iif wont evaluate

[Access Idiot]

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

 

[SusanV]

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

 

[Access Idiot]

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")
--
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

 

[Marshall Barton]

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.