Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1777
  • 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Jeffrey CoachmanCommented:
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

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

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