Quick Report Questions with some background info (just in case).

[Dave]

Using Access '03...Reports...

I have a report and designed the margins and the format (design) to have the
ability(space) to fit two records on one page. However, I can't seem to get
Access to go to the next record and place it on the same page (and so on).

All I have room for is two records per page... so, I have tried three ways
(listed below) with no success.
I greatly appreciate any advice or help.

Methods previously attempted:
-I attempted to create a sorting/grouping of only two records per page.
In the Details section, I select Sorting and Grouping from the view tab.
Then I placed “Name†for the field/expression and “Ascending†for Sort Order.
Then I set the following group properties: Group Header: No, Group Footer:
No, Group on: Each Value, Group Interval: 2, Keep Together: Whole Group.

- I have also tried to set the Height of the Details section (through
properties) to the min. it will allow me to 2.5â€. I also tried this with
changing the New Row Or Col. property to After Section.

-I have also tried Text Boxes with text counts and page breaks however, I am
unable to perform this...most likely due to my lack of
understanding/knowledge of this area. I believe this is the way however, I
need some help with the process/steps...the more basic the better. I am
starting to think that I may have to go to the properties of the Details
section and alter the page format with an expression but am unsure how to.

 

[Duane Hookom]

I would place a page break control at the bottom of the detail section and
name it "MyPageBreak". Add a text box to the detail section of the report:
Name: txtCount
Control Source: =1
Running Sum: Over All
Visible: No
Then add code to the On Format event module of the detail section:
Me.MyPageBreak.Visible = (Me.txtCount Mod 2 = 0)