If then in control source

  • Thread starter Thread starter Gee...
  • Start date Start date
G

Gee...

I'm running Access2002 and have this:

=IIf([Test1 Complete Date]=Null,"Test1 Incomplete","x")

in the Control Source of a Text Box. Why won't it work?
It's pulling from a Query that has all my tests'
completion dates.
If it's a blank...shouldn't Null work?
I hope I've explained this OK...
Thank you in advance for any help.

Gee...
 
I'm running Access2002 and have this:

=IIf([Test1 Complete Date]=Null,"Test1 Incomplete","x")

in the Control Source of a Text Box. Why won't it work?
It's pulling from a Query that has all my tests'
completion dates.
If it's a blank...shouldn't Null work?
I hope I've explained this OK...
Thank you in advance for any help.

Gee...
Click to expand...

=IIf(IsNull([Test1 Complete Date]),"Test1 Incomplete","x")
 
WooHoo Fred! That worked...so, thank you very much for re-
booting my sanity.
Gee..
-----Original Message-----
I'm running Access2002 and have this:

=IIf([Test1 Complete Date]=Null,"Test1 Incomplete","x")

in the Control Source of a Text Box. Why won't it work?
It's pulling from a Query that has all my tests'
completion dates.
If it's a blank...shouldn't Null work?
I hope I've explained this OK...
Thank you in advance for any help.

Gee...
Click to expand...

=IIf(IsNull([Test1 Complete Date]),"Test1 Incomplete","x")

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Back
Top