?
Solved

Access 2010 :: Grouping/Header question - First page is blank beneath group header.

Posted on 2011-09-06
3
Medium Priority
?
569 Views
Last Modified: 2012-05-12
I have an access report with a memo field that is very long (this is the report detail).  Is there any way to start the detail printing on the first page, beneath the group header (it's currently not printing on the first page of each group)?  I have it grouped by a field called fileNumber and the properties for the group header are:

keep together: yes
repeat section: yes
force new page: after section
0
Comment
Question by:ssailer
  • 2
3 Comments
 
LVL 10

Expert Comment

by:Luke Chung
ID: 36491808
the keep together property is triggering a page break before it when it exceeds the first page. Set that to No and it'll start on the first page.
0
 

Author Comment

by:ssailer
ID: 36492431
On the fileNumber group header, keep together is set to yes
0
 
LVL 10

Accepted Solution

by:
Luke Chung earned 2000 total points
ID: 36493237
Set all your group headers' KeepTogether properties to No.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

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

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Get the source code for a fully functional Access application shell with several popular security features that Access VBA application developers desire, but find difficult or impossible to figure out how to code. You get the source code for managi…
Suggested Courses

599 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