<p>I have a report with many fields that I'm trying to get down to 1 page horizontally (I don't care whether it's 2 or 200 pages vertically... just don't want to have to deal with 2 pages wide by x pages long train-wreck).  That said, it deals with contact information.</p>

<p>My idea was to do:</p>

<pre><code>Name:      Address:   City:      State:    ...
Jon Doe    Addr1      ThisTown    XX       ...    
           Addr2
           Addr3
-----------------------------------------------
Jane Doe   Addr1      ThisTown    XX       ...
           Addr2
           Addr3
-----------------------------------------------
</code></pre>

<p>Is there some way to set a <code>textbox</code> to be multi-line (or the SQL result)?  Have I missed something bloody obvious?</p>

<hr>

<p>The CanGrow Property is on by default, and I've double checked that this is true.  My problem is that I don't know how to force a line-break. I get the 3 address fields that just fills a line, then wraps to another.  I've tried <code>/n</code>, <code>\n</code> (since I can never remember which is the correct slash to put), <code>&lt;br&gt;</code>, <code>&lt;br /&gt;</code> (since the report will be viewed in a ReportViewer control in an ASP.NET website).  I can't think of any other ways to wrap the text.  </p>

<p>Is there some way to get the results from the database as 3 lines of text/characters?
­­­­­­­­­­­­­­­­­­­­­­­­­­­</p>

[{'answer_id': 26953, 'author': 'Sean Carpenter', 'author_id': 729, 'author_profile': 'https://Stackoverflow.com/users/729', 'pm_score': 2, 'selected': False, 'text': '<p>I believe you need to set the CanGrow property to <strong>true</strong> on the Textbox.  See <a href="http://msdn.microsoft.com/en-us/library/ms159116(SQL.90).aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/library/ms159116(SQL.90).aspx</a> for some details.</p>\n'}, {'answer_id': 30409, 'author': 'Pulsehead', 'author_id': 2156, 'author_profile': 'https://Stackoverflow.com/users/2156', 'pm_score': 6, 'selected': True, 'text': "<p>Alter the report's text box to:</p>\n\n<pre><code>= Fields!Addr1.Value + VbCrLf + \n  Fields!Addr2.Value + VbCrLf + \n  Fields!Addr3.Value\n</code></pre>\n"}, {'answer_id': 1663604, 'author': 'zhengokusa', 'author_id': 201212, 'author_profile': 'https://Stackoverflow.com/users/201212', 'pm_score': 1, 'selected': False, 'text': '<p>link break do this </p>\n\n<p>chr(10)</p>\n'}, {'answer_id': 3582842, 'author': 'Sam', 'author_id': 432755, 'author_profile': 'https://Stackoverflow.com/users/432755', 'pm_score': 3, 'selected': False, 'text': '<p>I had an additional problem after putting in the <code>chr(10)</code> into the database.</p>\n\n<p>In the field (within the report) add in:</p>\n\n<pre><code>=REPLACE(Fields!Addr1.Value, CHR(10), vbCrLf)\n</code></pre>\n'}, {'answer_id': 6849829, 'author': 'James An', 'author_id': 372645, 'author_profile': 'https://Stackoverflow.com/users/372645', 'pm_score': 2, 'selected': False, 'text': '<p>Hitting Shift+Enter while typing in the textbox creates a line break.</p>\n'}, {'answer_id': 16785761, 'author': 'Adriaan Davel', 'author_id': 776271, 'author_profile': 'https://Stackoverflow.com/users/776271', 'pm_score': 3, 'selected': False, 'text': '<p>My data was captured in a SL application, needed this for the field expression</p>\n\n<pre><code>=REPLACE(Fields!Text.Value, CHR(13), vbCrLf)\n</code></pre>\n'}, {'answer_id': 41986590, 'author': 'Community', 'author_id': -1, 'author_profile': 'https://Stackoverflow.com/users/-1', 'pm_score': 0, 'selected': False, 'text': '<p>Try this one :</p>\n\n<pre><code>= Fields!Field1.Value + System.Environment.NewLine + Fields!Field2.Value\n</code></pre>\n'}, {'answer_id': 45657284, 'author': 'Hemal', 'author_id': 2270492, 'author_profile': 'https://Stackoverflow.com/users/2270492', 'pm_score': 0, 'selected': False, 'text': '<p>In RDLC reports, you can convert a textbox to placehoder.\nThen right click that textbox placeholder, select placehoder properties and select HTML. Then for multiline to take effect, you have to insert <code>&lt;br/&gt;</code> tag between those lines.</p>\n'}]
['https://Stackoverflow.com/questions/26567', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/2156/']