How can I, in an IIF statement, create the true statement in red?

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

Guest

How can I, in an IIF statement, create the outcome to show in red?

ErrorbyPerson:IIF(table)!(field)=-1,"name"))

I want the "name" to appear in red in the query.

Is it possible?
 
You can't in a query.

In a form or report, there is a built-in feature (conditional formatting)
that will let you do this.
 

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

IIF statement to compare two fields. 3
Translate if statement in query 1
Multiple if statements 5
Choose append field based on criteria 4
IIF statement in query criteria, help! 2
IIF statement function criteria 10
IIF in Select Query 2
Mutiple IIF Statements 4

Back
Top