I am trying to write 1 formula to do this instead of 7 different formulas in 7 different sections suppressed if blank.

If "1" in (Field1) then
"Orange"

but also if "2" in (Field1) then
"Red"

but again if "3" in (Field1) then
also put "Green"
etc

If I use an else statement, of course, if the next if is true it will wipe out the last if and "&" seems to not work because it's if all is inclusive.

I think we had tried that before and it didn't work. I tried it just now and it didn't work.
If I use 'else' then red replaces orange and green replaces red, and I want it to just put them there along with the previous.
If I use '&' it looks like it is saying if all of these aren't in here then do not put any of these in here.

technically the parenth are not needed but I use them to keep track of each individual statement and you can replace the + with & if you prefer

Ugh, now this isn't working. This formula:
if "1" in ({Review.Level_I_Out_Serv_Value}) then
"1. Meeting in lunchroom:" & Chr(13)
+
if "2" in ({Review.Level_I_Out_Serv_Value}) then
"2. Meeting in classroom 4."
& Chr(13)
+
if "3" in ({Review.Level_I_Out_Serv_Value}) then
"3. Meeting in classroom 200."
& Chr(13)
+
if "4" in ({Review.Level_I_Out_Serv_Value}) then
"4. Meeting at town hall."
& Chr(13)
+
if "5" in (Review.Level_I_Out_Serv_Value}) then
"5. No meeting scheduled" & Chr(13)




If I don't pick "1" then I do get any data returned. Any ideas? Am I missing something?

Well, I had them on and it didn't work so I took them off. Now that I added them back, it works!