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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using iif Null and 0 5
Sum a field with null value 5
Combining SUM and IIF NULL Statement 5
SynNeed to account for null values in subreports 2
Iif Statement with Null Values 2
Problem with IIf 4
Access Building a IIF expression in Access 0
IIF FUNCTION and multiple values 2

Back
Top