Details won't show on the page one

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

Guest

I have a pretty long detail section in a report. It spans two pages. However
when i go to preview, the first page shows only the page header and another
header called StaffHeader, forces all of the details to the next two pages.
The headers only take up maybe two inches at the top of the page. Why wont
the details start on page one? I tried using page breaks but that didn't
work.
 
EvaDiva said:
I have a pretty long detail section in a report. It spans two pages. However
when i go to preview, the first page shows only the page header and another
header called StaffHeader, forces all of the details to the next two pages.
The headers only take up maybe two inches at the top of the page. Why wont
the details start on page one? I tried using page breaks but that didn't
work.
Click to expand...


Check to see if you have set the ForceNewPage property on
the header or detail sections. Also look at the detail
section's KeepTogether property.
 
I know that's the first thing someone was going to say..that's not my
problem. One detail record spans 2 pages, I don't have multiple records in
my detail section.
 
The keep together property attempts to keep the entire detail on one page.
If it is set to Yes (True) then Access will try to fit the entire detail
section for one record on one page.

So as Marshall asked did you look at the Detail section's keep together
property and make sure it was set to No?
From the online help
If the property is true then "Microsoft Access starts printing the section
at the top of the next page if it can't print the entire section on the
current page"

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
The most common cause of this is the Report Header section's
ForceNew Page. It would haved saved time if you said that
you had already checked those properties.

Other than having a Page Break control at the bottom of the
header or at the top of the detail section or some Sorting
and Grouping KeepTogether, I can't think of a thing you
could do to cause that effect.

A two page detail for one record is very unusual. Maybe you
have a weird combination of controls in the detail section
that's confusing Access? More information might help us
make an educated guess about the cause.
 
EvaDiva said:
I have a pretty long detail section in a report. It spans two pages. However
when i go to preview, the first page shows only the page header and another
header called StaffHeader, forces all of the details to the next two pages.
The headers only take up maybe two inches at the top of the page. Why wont
the details start on page one? I tried using page breaks but that didn't
work.
Click to expand...

There are a few questions that should be answered first

Are you using a sub report in the Details section?
Are you suppressing zeros?
Do you have any spaces between your data and the beginning or end of each
section?
Are your field values set to yes concerning Can Grow & Can Shrink?
Is your Details section set to yes concerning Can Grow & Can Shrink?

Lots to consider I’m sure there are more questions but these are the only
ones I can think of off hand.

K Board
 
EvaDiva said:
I have a pretty long detail section in a report. It spans two pages. However
when i go to preview, the first page shows only the page header and another
header called StaffHeader, forces all of the details to the next two pages.
The headers only take up maybe two inches at the top of the page. Why wont
the details start on page one? I tried using page breaks but that didn't
work.
Click to expand...


One more

Is Sorting and Grouping, Keep Together set to No?

K Board
 
Marshall didn't specify whether the detail section should be set to no or
yes. But that was it. I set it to no and it worked. Thanks.
 
Back
Top