Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 447
  • Last Modified:

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

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
zimmer9
Asked:
zimmer9
1 Solution
 
Rgonzo1971Commented:
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
 
mbizupCommented:
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
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

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

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