Get an iif statemnt to search for a null value?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
If FieldName1.value is null then
FieldName2.caption = “problem”
End If
 
Back
Top