• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 746
  • Last Modified:

"Can Grow" in Access Report

I have a report that pulls up a field that is attached to "memos". On the report, I have the property of it to "Can Grow" It is currently growing, but only to a certain point, and not enough. When the memos is really long, like 100 words or so it doesn't "grow" long enough. Any way of changing this to grow longer?
0
cansevin
Asked:
cansevin
2 Solutions
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Your control should grow as large as needed, unless you've got something that's stopping it. I've had Textboxes grow vertically to span two and three pages ... be mindful of controls "underneath" the control hosting your memo field and make sure your margins/borders don't overlap, even a tiny bit. This can cause some odd behavior.

Note also that you may have some odd results in the new Report Layout view, if you're using that view.
0
 
Jeffrey CoachmanMIS LiasonCommented:
This works fine for me with up to 1,000 words.

1 Check to make sure there are no strange characters in the text near the 100 word point.
2 Is this a Data type of "Memo" in the source table?

3 Is thie Report based on a Group By (Totals) Query?
If so, see here:
http://allenbrowne.com/ser-63.html
0
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now