Solved

Can grow = yes field on a report cutting off copy

Posted on 2014-09-18
7
167 Views
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
0
Comment
Question by:SteveL13
  • 4
  • 3
7 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
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
0
 

Author Comment

by:SteveL13
Comment Utility
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.
0
 

Author Comment

by:SteveL13
Comment Utility
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.

?????
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 

Author Comment

by:SteveL13
Comment Utility
And I wish there was a way to leave the spaces in the name but have the report print correctly.
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
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.
0
 

Author Comment

by:SteveL13
Comment Utility
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.
0
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
Comment Utility
is the scroll bar property of the textbox set to vertical? try removing it.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

762 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now