Access report where detail is different on odd and even pages

[Guest]

I want to create a report where the detail section has one design for even
pages and another design for odd pages

 

[Marshall Barton]

I want to create a report where the detail section has one design for even
pages and another design for odd pages

Since there is only one detail section, you will have to
manipulate the properties of the controls in the section
based on the page number:
If (Me.Page Mod 2) =1 Then
'odd page
. . .
Else
'even page
. . .
End If

How, you go about that probably depends on the complexity of
the differences. If it's just a matter of a few text boxes
being on the left or right side of the page, then adjusting
their Left property is pretty easy.

If the section doesn't have all that many controls but you
want to display a different set on on odd and even pages,
then put both sets of controls in the section and make the
appropriate ones visible/invisible.

If there are a large number of controls displayed with
significant differences between the pages, then you may want
to consider placing the two different layouts in separate
subreports so all you have to do is make one or the other
subreport visible/invisible. This requires that the main
report's record source be modified to only include the group
information and the subreports' record source queries
contain the detail data.

 

[Guest]

Or a 4th variation, create a new section in 'sorting and grouping', and
put all the (right) page controls in the footer of the new section.

Hide the detail or the footer section depending on which page you
are on.