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 2
Sum a field with null value 5
Auto fill in text box using iif function 3
Null Is Null 13
Access Combobox in Access Visible based on Checkbox 0
string together IIf statements into one text box? 3
Proper Syntax Required 2
Min and Max for Date Range in Report 4

Top