• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2372
  • Last Modified:

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

In other words, the label's caption is long and I want to break the text where I want--not where Access wants.
0
bobbat
Asked:
bobbat
1 Solution
 
Rey Obrero (Capricorn1)Commented:
does the report label varies?
upload a sample db with the report
0
 
bobbatAuthor Commented:
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
 
DoveTailsCommented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Jeffrey CoachmanMIS LiasonCommented:
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
 
GRayLCommented:
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
 
bobbatAuthor Commented:
Thanks to all for your interest.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now