 |
| The ENTER key breaks a text note. |
Carriage returns in Schedules are a different story. Pressing the ENTER key while editing a cell in schedule would not create a carriage return, but close the edit mode of a cell. The widely known workaround is using the shortcut CTRL+ ENTER.
 |
| The CTRL + ENTER key combination would create a carriage return. |
While CTRL+ENTER does work, editing the cell to add the desire break is really cumbersome. The schedule view would never display stacked lines, only single lines. The up and down arrow keys won’t jump the cursor to the paragraphs below, nor the PgDN or PgUP. The only way to make edits across multiple paragraphs is by dragging the cursor to the right or left and clicking the forward or backspace as many times as needed to get to the appropriate character.
 |
| Dragging a selection of text to the cell border would move the cell string to a different paragraph line. |
 |
| Do not use the drop down arrow selector in a multi-paragraph note. It will keep a single paragraph and remove the rest. |
We researched the issue and found a workaround reported by some users who were able to add an empty line by adding the ASCIII ‘empty space character’ code at the end of carriage return. (CTRL+ENTER followed by ALT+0160). I was, for some reason, unsuccessful to make it work, at least on my installed RAC 2015 R2 version.
But one way I make this work (or faking it to work?) is by adding a parameter that creates an invisible narrow column with enough character values to force the return. Here is the workaround: I created a new parameter of the integer type, added a number of characters equal to the number of lines plus one, and reduce the column width to a single character.
 |
| Create a blank space at the end of a cell, add a parameter that create a narrow invisible column with a number of characters equal the number of lines plus one, and change the column font color to RGB 254-254-254. |
 |
| RGB Color 254,254,254 will never print. |
To make the column invisible, change the font color. Changing to color to true white directs REVIT to display it in Black, therefore, change color to RGB 254,254,254 which is technically a grey color so light that it would never print.
The idea is to create populate the ‘invisible parameter’ with a total number of characters that equal to the amount of line spaces in a cell plus one.
The process can be automatized using Excel formulas. The formula parameters is explained below:
=LEN(C2)
|
Counts
the total number of characters in a cell
|
=CHAR
(10)
|
The
Excel function of the ‘line feed’ (carriage return) symbol
|
=SUBSTITUTE(C2,CHAR(10),"")
|
Delete
all the ‘line feed’ symbols in a cell (substitute them by ‘nothing’)
|
=LEN(C2)-LEN(SUBSTITUTE(C2,CHAR(10),""))
|
Count
the total number of ‘line feed’ symbols in a cell
|
The final formula to create a value that equal the amount of line spaces plus one is as follows:
=POWER(10,LEN(C2)-LEN(SUBSTITUTE(C2,CHAR(10),"")))*10
-If the number of line spaces in a cell is 2 = 100
- If the number of line spaces in a cell is 3= 1000
- If the number of line spaces in a cell is 4 = 10000… etc.
The data can then be reimported into Revit, forcing the ‘narrow’ column to wrap and giving you that magical carriage return space.
Watch a video on Carriage Returns on YouTube.
Cesar Escalante, AIA, LEED AP, CCCA
AEC Solutions Application Specialist
Cesar has a Bachelor of Architecture degree from the University of Central America in El Salvador, a Master of Architecture from the University of Texas, and is a CCCA (Certified Construction Contract Administrator). His experience includes roles as Project Manager and Project Captain at architecture firms in Oakland, California. As a member of the Ideate Tech Expert team, Cesar teaches Revit Architecture Fundamentals and provides client support and consulting. Cesar’s interest in the built environment includes his work as a volunteer for Habitat for Humanity.
Get it. Know it. Use it.
AEC Solutions Application Specialist
Cesar has a Bachelor of Architecture degree from the University of Central America in El Salvador, a Master of Architecture from the University of Texas, and is a CCCA (Certified Construction Contract Administrator). His experience includes roles as Project Manager and Project Captain at architecture firms in Oakland, California. As a member of the Ideate Tech Expert team, Cesar teaches Revit Architecture Fundamentals and provides client support and consulting. Cesar’s interest in the built environment includes his work as a volunteer for Habitat for Humanity.
Get it. Know it. Use it.
