Solved

How do I add a line break in a report's label control box?

Posted on 2011-03-21
6
1,201 Views
Last Modified: 2013-11-28
In other words, the label's caption is long and I want to break the text where I want--not where Access wants.
0
Comment
Question by:bobbat
6 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 35180861
does the report label varies?
upload a sample db with the report
0
 

Author Comment

by:bobbat
ID: 35181188
For example:
I want to change the caption that :
"Address, Phone Number and
 Email Address of Adopter"

To:
"Adopter's Address
Phone Number and
Email Address"

It seems it was two keystrokes, like Ctrl and an the apostrophe key.
SampleDatabaseWithReport.accdb
0
 
LVL 5

Accepted Solution

by:
DoveTails earned 500 total points
ID: 35181530
If you're simply entering the text for the label....hold the Shift key down and press enter.

If you're doing it in code ...    & vbCrLf     (stands for Visual Basic Carriage Return Linefeed.
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35182811
bobbat.

Although not relevant to the issue, your sample file contains only the report.
This means that it is difficult to actually test a solution, as the report will not open in Report view or Print Preview without a recordsource.
0
 
LVL 44

Expert Comment

by:GRayL
ID: 35183500
Click on the label in Design view.  Place the cursor where you want the new line to start and press Ctl+Enter - presto - new line with the remaining text.
0
 

Author Closing Comment

by:bobbat
ID: 35184411
Thanks to all for your interest.
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question