New Line in a Text box (1 Viewer)

[lisarmj]

I am creating a report and am concatentating the values of 120 text boxes into a single unbound text box. The reason for this is that the 120 text boxes are YES/NO and I only want the results to print when the value is yes.

The control source of the textboxes are:

=iif([fldname]=0,"","VALUE TO PRINT")

I would like to add a carriage return/line feed at the end so that the report will print the values one to a line.

I have tried:
=iif([fldname]=0,"","VALUE TO PRINT" & chr(13) & chr(10)) ,but am receiving a syntax error.

Any suggestions? I am using Access 2000 and the program will ultimately be used with Access 2003.

Thanks!

 

[Laurentech]

Try: & vbCrLf

Larry