Force New Line in columned Report

[gg80]

I am designing a sub report and would like to force a new line when a condition is met. Only one control in the report, whch is set for 4 columns , structured across then down. The presentation is meant to look like a CSV formatted document.
I am Using A2007 and A2003.

I have tried this expression in the query source control so that a new line would be forced if a condition is met.

IIf([SomeFactor]=1,[ControlName] & " & " & "chr(13)" & " & " & "chr(10)",[controlName]) & “, “


I have tried it with and without quotes with and without &, I also tried vbLF and vbCR in place of Chr(13) and chr(10).
even though consensus on visited sites seems to be that vb-- expressions are for visual basic only.

The few answers that I have found by googling various help sites mostly don't cover what to put in the query. The one or two that do just don't work (inluding this site)
Can someone tell me what simple thing I am missing?

Any help much appreciated.

[June7]

Don't put the Chr() functions in quotes, they are treated as literal strings if you do.

ControlName & IIf([SomeFactor]=1, Chr(13) & Chr(10), "") & ", "

[gg80]

Thanks for quick reply. I put the above expression in the query, but the report still doesn't give me a new line when it encountersthe vlaue with the CHR() statements. Is there something I should be doing with the report?

[June7]

Does it show the multi-lines in query? If so, it should carry over to report but I did not test. You could try expression in textbox ControlSource instead of in query.

If you want to provide db for analysis, follow instructions at bottom of my post.

[gg80]

I tried inserting Chr() etc. in the control box in the report, still no new line. Please don't analyze the table. In real life there is a lot of stuff in front of this simplified table. I made it this way to focus on what we are talking about, i.e., force a new line in a columned report if a condition is met. Thanks much for inviting me to send this to you, your help is much appreciated.

[June7]

The expression does not concatenate anything after the Chr(13) & Chr(10). What do you want to follow the CrLf?

ReptContrCHR: IIf([frac]=1, [item] & Chr(13) & Chr(10) & "something here", [QuanItem])

[gg80]

I se now that I was putting the LF in wrong place relative to the data. However, this doesn't work either. If I put expression within the report control, it just gives me a new line within the control, not a new line in the report (which maybe I didn't make clear that that what I was trying to do). I have been trying to avoid a cross tab query, but will go that route. Thanks much for taking time with this.

[June7]

Oh, no, can't add a 'line' in report that way.