Preventing orphans in Access report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi guys,

I'm new to using A-2000 but have picked up quite a lot from playing around
and reading these forums.

I have put together a fairly nifty database for a newbie, and have designed
the report output I need to see, however, some records are started on one
page and then continue on the next.

I know that you can prevent orphan lines of text in MS Word, and I hoped
someone would know a way of ensuring all of the data is kept together on
reports in Access.

Can anyone help please?
 
Access does not provide a way to prevent orphans and widows.

One workaround is to examine the Top property of the report in the Format
event of the (Detail?) section. If it is already too far down the page, then
toggle the Visible property of a Page Break control on to force a new page.

The Top property is measured in twips, where 1440 twips = 1 inch. The page
break control is in the toolbox, and it does have a Visible property even
though the intellisense does not show it.

If you want to keep all records in a group together, another workaround is
to place them in a subreport. Put the subreport in its own section on the
main report, and set that section's Keep Together property to Yes.
 
Back
Top