Concantenate Text Fields in a Report Control

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a control on a report where I want to concantenate four text boxes.
Doing the concantenating is no problem. I want to put a carriage return and
label between the fields. For example, what I have now is shown below:

=[COMMENTS] & " " & [CommentsShare] & " " & [CommentsMgmt] & " " &
[CommentsConfid]

I want it to be something like:

=[COMMENTS] & CarriageReturn & "Shared Comments" & CarriageReturn &
[CommentsShare] ... and so on.

I've tried Chr(13) for the carriage return, and that gives me a little box.

Any suggestions?

Thanks for your help.
 
Back
Top