• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2041
  • 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.
1 Solution
Rey Obrero (Capricorn1)Commented:
does the report label varies?
upload a sample db with the report
bobbatAuthor Commented:
For example:
I want to change the caption that :
"Address, Phone Number and
 Email Address of Adopter"

"Adopter's Address
Phone Number and
Email Address"

It seems it was two keystrokes, like Ctrl and an the apostrophe key.
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.
7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.

Jeffrey CoachmanMIS LiasonCommented:

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.
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.
bobbatAuthor Commented:
Thanks to all for your interest.
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

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

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