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 / September 2007

Tip: Looking for answers? Try searching our database.

Preventing Text Boxes from being Cut in the middle

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Anatoly Kurilin - 30 Sep 2007 16:02 GMT
Hi, I have a report without Record Source which contains several subreports
and two rows of unbound text boxes in the detail section (text boxes a
situated beneath the subreports). It works fine except that when one row of
unbound boxes get on bottom of a page they are cut in the middle. I've tried
several tricks - created Record Source to the report containing one record
and added a bound text box beside the unbound text boxes but the bound text
box was also cut in the middle (?).

Theoretically, I need all these unbound box being moved to the next page if
one row gets on the bottom edge of the page but I would be satisfied if they
will be split without cutting in the middle.

Thank in advance,
AK
Marshall Barton - 30 Sep 2007 20:44 GMT
>Hi, I have a report without Record Source which contains several subreports
>and two rows of unbound text boxes in the detail section (text boxes a
[quoted text clipped - 7 lines]
>one row gets on the bottom edge of the page but I would be satisfied if they
>will be split without cutting in the middle.

It sounds like you want to simulate a KeepTogether property
for aome text boxes.  Unfortunately, only sections and
groups have this property.  This means that you need to put
the text boxes in their own section.

Create a group level with footer on the record's primary key
field.  Then move the text boxes to the group footer section
and set its KeepTogether property.

Signature

Marsh
MVP [MS Access]

 
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.