Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / April 2007

Tip: Looking for answers? Try searching our database.

break word in reports

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
HungTano - 11 Apr 2007 05:15 GMT
Hi all,
I have a text field in table. When I print report based that table, the word
in text field break apart.
Example : data in text field : "This is a dangerous film"

But in report : This is a danger
                   ous film

Because The report has many columns, I can not wide the length of text field.

Thanks !
rvanclea - 12 Apr 2007 16:36 GMT
I assume you have the "can Grow" property set to true in this text box. I am
also assuming that the textbox is big enough to handle all words in your
table if the lines were to break between them (if not, you either need to
exand the textbox or make the font smaller).

I know of no property that forces line breaks in this situation to always
occur at a blank, so the only solution that comes to my mind is to create a
few extra text fields in your table that are hidden to users, and write some
VBA code that will parse your text field into these hidden fields. You then
would have control over where the breaks occur.

Then, stack these fields in your report column rather than use the original
field. You could automatically run the code each time the report is opened.  
Seems like a bit of work, but that is all that comes to mind.

> Hi all,
> I have a text field in table. When I print report based that table, the word
[quoted text clipped - 7 lines]
>
> Thanks !
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.