Solved

In Access 2003, how would you break a Caption string value so that it appears in 2 separate lines?

Posted on 2013-11-01
2
426 Views
Last Modified: 2013-11-01
In Access 2003, if I go into DESIGN mode and navigate to a LABEL and double click on it,
then I am brought to the properties options for the LABEL.

Within the CAPTION, if I want to input the following value on 2 separate lines:

Import Automated Files: (DRS, WRS, Intellimatch, Balance, Pending)

How would I be able to make the CAPTION appear on 2 lines and break as follows:

Import Automated Files:
(DRS, WRS, Intellimatch, Balance, Pending)
0
Comment
Question by:zimmer9
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 52

Expert Comment

by:Rgonzo1971
ID: 39616639
Hi,

pls try
Me.Label1.Caption = "Import Automated Files:" & Chr(13) & "(DRS, WRS, Intellimatch, Balance, Pending)"

Open in new window

or
Me.Label1.Caption = "Import Automated Files:" & vbNewLine & "(DRS, WRS, Intellimatch, Balance, Pending)"

Open in new window

Regards
0
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 39616641
No-code solution:  You can edit the text of the label directly, and hit Ctrl-Enter where you want the line break to appear.
1

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

622 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