Divided Spacing on Reports:Acc97

[Lumpierbritches]

Thank you in advance for any and all assistance. I'm trying to create a report
that will work similar to the label wizard in Access. I have a premade form I'm
attempting to fill with data from the db. I can manually make the information
fit, by making the report the full 8.5" x 11", however, when I attempt to size
the report so that an individual record prints in each one, the sizing is all
off. Is there a secret for dividing up the report page with .50 footer and .50
header with .25 and .251 repspectively right and left margins to get say
"three" (3) even records?

Also, does each record require the .50 header and footer to computated for
spacing also? If that's the case, you loose 3" in an 11" form????

I have tried using the label wizard customized and can't get it to work, PLEASE
help with this. The form is PrePRINTED and I'm attempting to fill in fields on
this preprinted form. They are also perferated every 3.75", which when I try
and make the label that big, I loose the third section of the form.

Michael

[Allen Browne]

You want 3 labels on a Letter-sized page, with the text placed exactly the
same on each. But you must allow for half-inch margin top and bottom of the
page. The solution is to create a group footer that prints every record, and
suppress it on the 3rd label.

1. Open (or create) the report in design view.
Choose Page Setup from the File menu, and set the top and bottom margins to
0.5 inch.

2. Set the Height of the Detail section to 3 inch.

3. Add a text box to the Detail section, and give it these properties:
Control Source =1
Running Sum Over All
Name txtCount
Format General Number
Visible No

4. Open the Sorting And Grouping dialog (View menu).
Select your primary key field.
In the lower pane of the dialog, set Group Footer to Yes.
Set the Height of this section to 0.5 inch.

5. To suppress this group footer for the 3rd label on the page, set the On
Format property of this group footer section to:
Event Procedure
Click the Build button (...) beside this.
Access opens the code window.
Add this line between the "Private Sub ..." and "End Sub" lines:

Private Sub GroupFooter0_Format(Cancel As Integer, FormatCount As
Integer)
Me.GroupFooter0.Visible = (((Me.txtCount - 1) Mod 3) <> 2)
End Sub

In the end, your 11" tall page looks like this:

,------------------------------------
| 0.5" Page Header
|---------------------------
|
| 3.0" Label 1
|
|-----------------
| 0.5" Group Footer (Spacer)
|--------------------------
|
| 3.0" Label 2
|
|-----------------
| 0.5" Group Footer (Spacer)
|---------------------------
|
| 3.0" Label 3
|
|-------------------------- (suppressed group footer is zero height here)
| 0.5" Page Footer
`--------------------------------------

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Lumpierbritches" <lu*************@aol.com> wrote in message
news:20***************************@mb-m07.aol.com...

Thank you in advance for any and all assistance. I'm trying to create a
report
that will work similar to the label wizard in Access. I have a premade
form I'm
attempting to fill with data from the db. I can manually make the
information
fit, by making the report the full 8.5" x 11", however, when I attempt to
size
the report so that an individual record prints in each one, the sizing is
all
off. Is there a secret for dividing up the report page with .50 footer and
.50
header with .25 and .251 repspectively right and left margins to get say
"three" (3) even records?

Also, does each record require the .50 header and footer to computated for
spacing also? If that's the case, you loose 3" in an 11" form????

I have tried using the label wizard customized and can't get it to work,
PLEASE
help with this. The form is PrePRINTED and I'm attempting to fill in
fields on
this preprinted form. They are also perferated every 3.75", which when I
try
and make the label that big, I loose the third section of the form.

Michael

[Allen Browne]

Sorry: to get exactly the same layout, the Group Footer (spacer) section
needs to be 1 inch high. That leaves 2.6666 inch high for each label.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:41***********************@per-qv1-newsreader-01.iinet.net.au...

You want 3 labels on a Letter-sized page, with the text placed exactly the
same on each. But you must allow for half-inch margin top and bottom of
the page. The solution is to create a group footer that prints every
record, and suppress it on the 3rd label.

1. Open (or create) the report in design view.
Choose Page Setup from the File menu, and set the top and bottom margins
to 0.5 inch.

2. Set the Height of the Detail section to 3 inch.

3. Add a text box to the Detail section, and give it these properties:
Control Source =1
Running Sum Over All
Name txtCount
Format General Number
Visible No

4. Open the Sorting And Grouping dialog (View menu).
Select your primary key field.
In the lower pane of the dialog, set Group Footer to Yes.
Set the Height of this section to 0.5 inch.

5. To suppress this group footer for the 3rd label on the page, set the On
Format property of this group footer section to:
Event Procedure
Click the Build button (...) beside this.
Access opens the code window.
Add this line between the "Private Sub ..." and "End Sub" lines:

Private Sub GroupFooter0_Format(Cancel As Integer, FormatCount As
Integer)
Me.GroupFooter0.Visible = (((Me.txtCount - 1) Mod 3) <> 2)
End Sub

In the end, your 11" tall page looks like this:

,------------------------------------
| 0.5" Page Header
|---------------------------
|
| 3.0" Label 1
|
|-----------------
| 0.5" Group Footer (Spacer)
|--------------------------
|
| 3.0" Label 2
|
|-----------------
| 0.5" Group Footer (Spacer)
|---------------------------
|
| 3.0" Label 3
|
|-------------------------- (suppressed group footer is zero height here)
| 0.5" Page Footer
`--------------------------------------
"Lumpierbritches" <lu*************@aol.com> wrote in message
news:20***************************@mb-m07.aol.com...

Thank you in advance for any and all assistance. I'm trying to create a
report
that will work similar to the label wizard in Access. I have a premade
form I'm
attempting to fill with data from the db. I can manually make the
information
fit, by making the report the full 8.5" x 11", however, when I attempt to
size
the report so that an individual record prints in each one, the sizing is
all
off. Is there a secret for dividing up the report page with .50 footer
and .50
header with .25 and .251 repspectively right and left margins to get say
"three" (3) even records?

Also, does each record require the .50 header and footer to computated
for
spacing also? If that's the case, you loose 3" in an 11" form????

I have tried using the label wizard customized and can't get it to work,
PLEASE
help with this. The form is PrePRINTED and I'm attempting to fill in
fields on
this preprinted form. They are also perferated every 3.75", which when I
try
and make the label that big, I loose the third section of the form.

Michael