Control detail section height size in Ac2007

  • Thread starter Thread starter VBNovice10
  • Start date Start date
V

VBNovice10

Hi,

I am new to Access and have created most of my Report/Database reading these
forums. I am using Access 2007 and I am having problems with my report
format, specifically the details section. Currently, my report is linked to
a table and modeled after a Word document. I have a page header, a group
header 'repeated in every section', a detail section, a group footer, a page
footer, and a report footer with Force New Page set to 'Before Section'.

My problem is in the detail section. The detail section is grouped by Field
'Doc#' set at 'keep whole group together on one page' then sorted by Field
'Item#'. Each Item# is associated with rows autofilled by the database.

I would like th number of rows on the same page as the group footer to
always equal to 2. For example, if I have 7 Item#s, then I would like 5 rows
autofilled on previous pages and the last 2 on a separate page with the group
footer. The number of Item#s vary with each associated Doc#.

Thank you in advance.
 
Hi Marshall,

Thank you for your help. The code did not produce the response I wanted.
The page break is separating each row onto its own page. The last page also
only has the 7th row.

Please let me know what information I can provide you to remedy the problem.

Thank you.
 
Thank you,

Everything worked out as planned. The security settings had disabled
macros. I reset the settings to enable macros and your VBA code worked
perfectly.

Thank you again.

Marshall Barton said:
You must have done something unusual. Maybe you added two
page break controls? Maybe the header and or detail text
boxes are not set as I said? Maybe you have ForceNewPage
set for the detail section? Maybe the line of VBA is wrong?
Or maybe ???

Without more specific information, all I can say is to
double check everything.
--
Marsh
MVP [MS Access]

Thank you for your help. The code did not produce the response I wanted.
The page break is separating each row onto its own page. The last page also
only has the 7th row.

Please let me know what information I can provide you to remedy the problem.
Click to expand...
.
Click to expand...
 
Back
Top