Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 348
  • Last Modified:

Access 2002 Report - Break a text line on a space

I have a report which has to display a number of long lines of text.  Inevitably this text is too long for a single line space.  So the text needs to be broken at a logical BLANK space and then continued on the next line.  An example of how Access handles it is shown below.  Access breaks the line in the middle of a word and does not print the rest of the word before continuing the text on the next line.

Is there a way to have Access break this text at a blank automatically - or do I have to write a VBA routine to format the text properly?
This long line of text should be broken at a blank space before continu
to the next line.  Breaking in the middle of a word is not acceptable.

Open in new window

0
ljcor
Asked:
ljcor
  • 3
  • 2
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<Is there a way to have Access break this text at a blank automatically - or do I have to write a VBA routine to format the text properly?>>

  None that I'm aware of.  You'd have to write a routine to reformat the text putting in a vbCRLF at the apporpriate spots based on the width of the control.

  Font type and size would need to be taken into account.

JimD.
0
 
peter57rCommented:
Access does not work like that for me.  It always breaks on word boundaries.
Which version of Access is this?
How did you create the report?

0
 
ljcorAuthor Commented:
peter57r

I am using Access 2002 which comes in Office 2003 (go figure.)

I created the report by:  Clicked on Reports, clicked on New, Clicked on AutoReport Tabular.  Then I selected a Table whick has a few fields including one with the long lines of text.

I just did this again for a new report and it worked just fine, breaking on a word boundry.  I thought it did that the first time I tried this awhile back, too.  However, when I modified the length of the line in Design view it started chopping off the word.  I don't know why.  Perhaps you have an idea.  Either way I will accept your solution since that is just how I want it to work.

0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
ljcorAuthor Commented:
Thanks, Peter.
0
 
peter57rCommented:
I have tried messing around with the size of the textbox but can't create a problem except when it is so narrow that the whole word does not fit on one line. Otherwise it is consistently breaking on a word boundary.
Sorry I can't throw any light on the problem.
0
 
ljcorAuthor Commented:
Good enough.   I will just do it all over again - particularly since it is no problem.  Thanks again.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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