troubleshooting Question

Using a New Line Character in Expression Builder

Avatar of jdobbs88
jdobbs88 asked on
Microsoft AccessMicrosoft Applications
6 Comments1 Solution477 ViewsLast Modified:
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.

A
C

Is there a 'New Line' character that I can use between the IIf statements to display the results on a seperate line.

Thanks.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 6 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros