help with Control Source expression error

Question

I am having trouble with an expression in a report.  I am trying to write a conditional, where if "Status" field = "Inactive"  and Program Type field = "o" then display the Program Title and append a date onto the end of it, else just display the Program Title.

=IIf([Program Approvals]![Status]="Inactive" And [Program Approvals]![Program Type]="o",[Program Approvals]![Program Title]+CStr([ [Program Approvals]![Inactive Expires]),[Program Approvals]![Program Title])

When I run it I am getting :  " is not a valid name.  make sure that it does not include invalid characters or punctuation and that it is not too long.

That is not very helpful!  I did use the Expression Builder to write it.   Is there a way to see the SQL that is produced when one write an expression?  That could help me figure it out.

Answer 1

That was one of my choices, to run it from the query and to me, a much better way to do it.

Answer 2

I ended up approaching it a different way.  I don't know if it's wrong to do it this way though.  (this is my first Access project).  I made an alias column in the source query and concatenated them there.

Answer 3

Is it possible that Status or Program Type is empty?  By that I mean there no entry in either of the fields?  That is the most common cause of the error.  If it were me I would either write it in a query and account for NULL's or put it in VBA Editor behind the form in the On_Current event, again accounting to NULL's.