Keep Titles And Data Together in Access Reports
If you run large reports, you’ve probably run into a problem where the
title of a group or subgroup appears all by itself at the bottom of a page,
and the data associated with it appears
without a title on the next page. It looks really stupid and
makes the report very hard to read. The ability to keep titles and text
together in Microsoft Word is called Widow and Orphan control. In Access
reports it’s called Keep Together.
In report design view, you can click on the Sorting and Grouping Icon
below circled in yellow, or you can right-click anywhere on the report and
choose Sorting and Grouping from the pop-up menu. You should see the dialog
box below.
Are You Ready For Office 365?
Office 365 is
- Email and calendaring powered by Microsoft Exchange
- Office Web Apps - the office productivity apps you already know, tailored for the
web
- Websites powered by Microsoft SharePoint both for internal-facing intranet and customer-facing
website
- Instant Messaging and Online Meetings powered by Microsoft Lync
- All with a financially-backed 99.9% uptime guarantee
Sign up for a free trial:
Your information will not be shared with any other party. You must provide
a valid email in order to recieve your login information and starting information
kit.
Watch
this video to see how Office 365 can help your business.
Choose the section you’d like to modify (in the picture above we’re
changing the Owner section) and then go to the Keep Together section circled
in red. The Whole Group setting will attempt to put the title and all of the
associated data on one page, the With First Detail setting will put one or
two lines of data on the same page as the title, and the rest on the next
page.
Do be careful with this! While it’s nice to have all of your data
display together, a simple innocent change like the one above can turn a 30
page report into a 100 page report! Consider for a moment how this setting
works:
- You keep a title with the whole dataset
by placing the title at the top of the page
- You keep the title at the top of the page
by inserting a Page Break at the bottom of each section
- More Page Breaks = more white space (wasted space) at
the bottom of each page
- More white/wasted space per page =
more pages!
It’s not unusual to double or triple the size of your reports by using
the Whole Group setting, so do a Print Preview first!
|
|