Syntax Error

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")
 
D

Duane Hookom

You are missing the "=" as the first character in the expression. I would try
=IIf(IsNull([Test Scenarios]),"","Exists")
 

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

Show phrase when no data for a report 3
Sum a field with null value 8
IIf works in query but not in report 1
Null Is Null 13
Text field control source wont accept results of query 1
Need help modifying code 0
Proper Syntax Required 2
Auto fill in text box using iif function 3

Top