Can grow = yes field on a report cutting off copy

Posted on 2014-09-18
Last Modified: 2014-09-18
I have a field on a report which is a text field set to Can Grow = Yes.  But the report is cutting off on the right hand side like the attached screen shot shows.  Is there a fix for this?

See screen shot.Example of cut off text
Question by:SteveL13
  • 4
  • 3
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 40330289
a quick fix for that, without resizing your textbox horizontally is
to fix the images name, remove spaces and keep length of image name consistent

Author Comment

ID: 40330306
I'm not sure I know what you mean by "Fix the images name".

I manually removed the spaces in the table field and got the same result.

I can't keep the image name length consistent.  They have to vary.

Author Comment

ID: 40330355
I just discovered that if I remove any spaces in the file names, for example, "Love Seat.jpg" renamed to "LoveSeat.jpg", (no spaces in the name), it works fine.

But I don't understand why that would fix it.

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.


Author Comment

ID: 40330392
And I wish there was a way to leave the spaces in the name but have the report print correctly.
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 40330394
that is the normal textbox  wrap text behavior, when the line of text cannot be fitted horizontally, it will split the text on the first space it finds and place the trailing text to the next line.

Author Comment

ID: 40330406
I understand that and I'm ok with that.  But what is happening is it is cutting off a letter...see the example screen shot.  The "e" in the work Love is only half there.
LVL 120

Accepted Solution

Rey Obrero (Capricorn1) earned 500 total points
ID: 40331629
is the scroll bar property of the textbox set to vertical? try removing it.

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
database opened as read only 10 32
Run Stored Procedure uisng ADO 5 21
How to Pass Line Number to Error Handler in MZ Tools 7 17
Search feature 14 26
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question