insert a line feed character in a formula of a text field

Posted on 2006-05-18
Last Modified: 2013-11-15
I want to insert a line feed character in a formula.  For example, my formula for text1 is: [Text2] & chr(10) & [Text3].  My Text1 value is always #ERROR.  I know this formula works if I change it to [Text2] & chr(65) & [Text3].  65 is the A character.  

This is somewhat urgent...hence 500 pts...I would like to get this solved today
Question by:LT012345
    LVL 15

    Expert Comment

    Is this in Project?

    No matter...try it with 10 and 13...I know thats how I used to do it in apps like Crystal Reports.

    [Text2] & chr(10)& chr(13) & [Text3]

    Author Comment

    Yes, MS Project 2003.  
    Nope, doesn't work.  Text1, with the formula, still displays #ERROR
    LVL 35

    Expert Comment

    You can't enter control characters in text fields in MS Project. Therefore, dbase118 is right in general, but it will not work in Project.

    What you can do is, enter your text without control characters and change the high of the row.

    Author Comment

    Bembi, unfortunately, you're about Project text fields not being able to accept control characters.  What we did is we use:  [Text2] & Space(1) & [Text3].  Then change the height of the row so it will wrap.  

    Author Comment

    Correction to previous post:
    Should have read "you're right about" instead of "your're about"
    LVL 35

    Accepted Solution

    Thats what I wanted to say, assumed, you have some spaces in a longer text anyway. But this is the only way to wrap the text, but not really have control over, where it wraps as long as you have more than one space. Maby you want to use filling characters like underscores to have a little bit mor control, where project should wrap the text.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Re-planning is just as important as planning. MS Project files need to be updated regularly to reflect the current status of the project and to streamline the upcoming tasks. We have seen a lot of issues where project managers have not updated the p…
    "Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now