IIf statement

  • Thread starter Thread starter jmoore
  • Start date Start date
J

jmoore

=IIf([F6]=#1/1/7777#,"Not Available",IIf([F6]=#1/1/9999#,"Not
Applicable",[F6]))

This statement is in the control source of a report text box, and it
displays the data I want. I tried placing the Chr(13) & Chr(10) between not
applicable and not available, in several configurations, but could not get it
to display on two lines. Am I trying to do the impossible?

Thanks.
 
but could not get it to display on two lines.
Only one will display each time. Maybe show how you want it to look in
the report.
 
=IIf([F6]=#1/1/7777#,"Not Available",IIf([F6]=#1/1/9999#,"Not
Applicable",[F6]))

This statement is in the control source of a report text box, and it
displays the data I want. I tried placing the Chr(13) & Chr(10) between not
applicable and not available, in several configurations, but could not get it
to display on two lines. Am I trying to do the impossible?

Thanks.
Click to expand...

Are you trying to have the words "Not Available" or "Not Applicable"
display on 2 lines? i.e.
Not
Available
.... or ...
Not
Applicable

=IIf([F6]=#1/1/7777#,"Not" & chr(13) & chr(10) &
"Available",IIf([F6]=#1/1/9999#,"Not" & chr(13) & chr10) & "
Applicable",[F6]))

If you mean something else than a bit of clarification and an example
would be in order.
 
Back
Top