Field size in report

I have a field in a report that pulls data that could be multiple paragraphs long or it can be as short as a few words. Currently it is growing to the length to fit the entire entry.

How can I limit the grows to be around 5 lines?
Who is Participating?
David Johnson, CD, MVPOwnerCommented:
define 5 lines (5 x 80 characters?) if so then trim it to 400 characters
What reporting tool are you using?

I know Crystal Reports has a setting in the formatting for maximum number of lines.  I don't know about SSRS.

If there is no max lines setting then a calculation like above would be an easy way to do it.

Do you need the entire text available?

cansevinAuthor Commented:
Thank!... I am using a report in Microoft Access. I can't find the "trim" in the format section. Currently I have it "Can Grow- Yes"

Is there a way to limit the growth?
cansevinAuthor Commented:
Just any way to limit the growth is fine... if its Characters, inches, or anything. Just a way to say... "don't grow bigger than this."
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.