IIf statement

[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.

 

[KARL DEWEY]

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.

 

[fredg]

=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.

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.