Solved

Access 2002 Report - Break a text line on a space

Posted on 2008-10-23
6
338 Views
Last Modified: 2012-06-27
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
Comment
Question by:ljcor
  • 3
  • 2
6 Comments
 
LVL 57
ID: 22785123
<<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
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 22785140
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
 

Author Comment

by:ljcor
ID: 22785472
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
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 Closing Comment

by:ljcor
ID: 31509155
Thanks, Peter.
0
 
LVL 77

Expert Comment

by:peter57r
ID: 22785589
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
 

Author Comment

by:ljcor
ID: 22785707
Good enough.   I will just do it all over again - particularly since it is no problem.  Thanks again.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Familiarize people with the process of utilizing SQL Server functions 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 Ac…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

943 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

3 Experts available now in Live!

Get 1:1 Help Now