Access Reports

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

Guest

I am setting up a report to show repaired items grouped by part number and
orderd by repair date. In the detail section, I have several fields (ie.
serial#, part name, etc.) One of the fields is the resolution field. This
field can shrink and grow based on the detail my techs decide to put into it
on what they did to fix the problem. The problem I am having with my report
is ... I can usually fit 4-5 entries per page with the layout I have.
However, when a resolution has to grow, it will cause some entries to get cut
off on the bottom of the page and be half on one page /half on the other. Is
there a way in VBA, or a property I can set to manipulate the format of the
report in such way as to check if a detail section will get cut off? Then, if
true, insert a page break prior to that detail section so it keeps each issue
complete on a page? Thank you in advance for all your help!
 
Jbrous said:
I am setting up a report to show repaired items grouped by part number and
orderd by repair date. In the detail section, I have several fields (ie.
serial#, part name, etc.) One of the fields is the resolution field. This
field can shrink and grow based on the detail my techs decide to put into it
on what they did to fix the problem. The problem I am having with my report
is ... I can usually fit 4-5 entries per page with the layout I have.
However, when a resolution has to grow, it will cause some entries to get cut
off on the bottom of the page and be half on one page /half on the other. Is
there a way in VBA, or a property I can set to manipulate the format of the
report in such way as to check if a detail section will get cut off? Then, if
true, insert a page break prior to that detail section so it keeps each issue
complete on a page?
Click to expand...


Just set the detail section's KeepTogether property to Yes.
 
The keep together property is set to yes and has no effect. The record still
splits between two pages.
 
Jbrous said:
The keep together property is set to yes and has no effect. The record still
splits between two pages.
Click to expand...


I've never heard of that failing to make a section that
doesn't fit on the current page from starting on a new page.

If you are trying to keep the entire group on a page, then
set the group's KeepTogether property (in Sorting and
Grouping) to Whole Group.

If I'm still missing the point of your problem, please
provide more details about your report's settings, grouping,
and problem.
 
Back
Top