Syntax Error

  • Thread starter Thread starter Jimbo213
  • Start date Start date
J

Jimbo213

On a report, if the field [Test Scenarios] is empty I want to print "", else
"Exists"

A previous post said to make sure the text box was not named the same as the
control source. Which I have corrected.

What's wrong with this code in the control source property of a text box
named ExistsTestScenario:

IIf([D7-MASTER]![Test Scenarios] Is Null,"","Exists")
 
You are missing the "=" as the first character in the expression. I would try
=IIf(IsNull([Test Scenarios]),"","Exists")
 
Back
Top