Concantenate Text Fields in a Report Control

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.
 
R

Rick B

=[COMMENTS] & chr(13) & chr(10) & "Shared Comments" & chr(13) & chr(10)...





Rick B
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using OpenArgs in a Report 5
Inserting Carriage Return in Expressions? 4
Inserting carriage return in report field 3
Concantenate All cells in Row left of current active cell-- 8
Carriage return in a text box in a textbox in report. 4
Combine / Concatenate text and include a carraige return 2
Report control: hide blank row when null data 2
Split data in field on character return 0

Top