Solved

Can grow = yes field on a report cutting off copy

Posted on 2014-09-18
7
182 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
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
0
 

Author Comment

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

Author Comment

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

?????
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:SteveL13
ID: 40330392
And I wish there was a way to leave the spaces in the name but have the report print correctly.
0
 
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.
0
 

Author Comment

by:SteveL13
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.
0
 
LVL 120

Accepted Solution

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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Best way to get data into a database 12 56
MS Access vba Print  PDF First page only 16 34
Conditionally trimming using VBA 8 36
Outlook mail to Access 8 28
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

751 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