Get an iif statemnt to search for a null value?

J

Julianne

You all have been so wonderful and extremely helpful. May I borrow upon your
expertise again? In a report I would like to create a text box that checks
to see if a field has a null value. I've been using the Iif function but am
at a loss as how to ask it to "check to see if the field is blank. If it is,
return the word "problem." Thank you again and again for sharing your
knowledge. Happy Holidays and a joyous New Year.
 
B

BabyATX13 via AccessMonster.com

If FieldName1.value is null then
FieldName2.caption = “problem”
End If
 
Top