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
This is somewhat urgent...hence 500 pts...I would like to get this solved today
ASKER
Yes, MS Project 2003.
Nope, doesn't work. Text1, with the formula, still displays #ERROR
Nope, doesn't work. Text1, with the formula, still displays #ERROR
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.
What you can do is, enter your text without control characters and change the high of the row.
ASKER
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.
ASKER
Correction to previous post:
Should have read "you're right about" instead of "your're about"
Should have read "you're right about" instead of "your're about"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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]