Using a New Line Character in Expression Builder
Posted on 2007-07-30
Ok, here is my problem. I have one text box that I'm joining multiple fields into with IIf() statements. The problem is I need each field to appear on a new line. For example;
IIf(field1 = "A","A",Null) & IIf(field2 = "C","C",Null)
I need the results to appear like this following, assuming both statements are true.
Is there a 'New Line' character that I can use between the IIf statements to display the results on a seperate line.