Link to home
Start Free TrialLog in
Avatar of LT012345
LT012345

asked on

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

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
Avatar of dbase118
dbase118
Flag of United States of America image

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]
Avatar of LT012345
LT012345

ASKER

Yes, MS Project 2003.  
Nope, doesn't work.  Text1, with the formula, still displays #ERROR
Avatar of Bembi
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.
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.  
Correction to previous post:
Should have read "you're right about" instead of "your're about"
ASKER CERTIFIED SOLUTION
Avatar of Bembi
Bembi
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial