I am designing a report. There are 3 columns with across then down structure.. Only one control is displayed. Using A2007 and A2003.
If a condition is met, I would like to start a new line on the report. I have tried this expression in control's query source for the report.
= IIf([Fctr]=1,[data1] & " & " & "chr(13)" & " & chr(10)",[data1])
Apparently all controls have to be in the same textbox for this type of thing to work. Is there some way to do what I want?
If a condition is met, I would like to start a new line on the report. I have tried this expression in control's query source for the report.
= IIf([Fctr]=1,[data1] & " & " & "chr(13)" & " & chr(10)",[data1])
Apparently all controls have to be in the same textbox for this type of thing to work. Is there some way to do what I want?