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

Posted on 2006-05-18
Medium Priority
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
  • 3
  • 2
LVL 15

Expert Comment

ID: 16709948
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

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

Expert Comment

ID: 16710914
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.
[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.


Author Comment

ID: 16710999
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

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

Accepted Solution

Bembi earned 1500 total points
ID: 16722267
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.

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

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

Article by: x-men
Where used to see Gantt charts for illustrating project timelines, but what if I wanted to visualize passed timed events? Here's how.
A simple overview of the possibilities of using technology for project management.
Integration Management Part 2
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

864 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