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
404 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
2 Comments
 
LVL 49

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

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…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

803 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