Knowledge Base

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

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.

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

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit