Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

## Knowledge Base

## How can I create a condensed version of text field on a report or form?

In order to show a portion of a particular field's data on a report and/or form, you need to take these two steps: 1) Create a new formula field that will hold the subset of the original field's data, and 2) Add the new formula field to the forms and reports where you want the condensed field showing. To create the formula field that truncates a text field, you will want to use one of the three formula functions: Left(), Right() and/or Part(). Here are some examples of what could be in the formula for the new field: 1) "Left([LongField], 228)" will display the first 228 charachers of "LongField". 2) "Right([LongField], 1000)" will display the last 1000 characters of "LongField". 3) "Part([LongField],2,":")" displays everything between the 2nd and 3rd colon. For more examples, please see our Text Functions section of the Formula Functions Reference.

- 36162 reads

## Rate This

## Similar Articles

## Browse by Category

### Knowledge Base Categories

- Accounts (31)
- Application (57)
- E-Mail (7)
- Fields (38)
- Forms (18)
- Formulas (18)
- General (72)
- Other Product (7)
- Pages (1)
- Product (5)
- Reports (14)
- Roles (4)
- Search (1)
- Tables (5)

## Comments

## an update from a friendly user!

Using the following formula, as opposed to the ones offered in the article, will give you results with no truncated words and and elipsis (...) if there is additional data beyond the snip-it.

If(Length([LongField])<301, [LongField], NotRight(Left([LongField], 300)," ")&"...")

## Post new comment