Avery 5963

[Dave Elliott]

Is there a way that I can make access print my labels without using the
wizard?
Report name is RLabels
Using Template Avery 5963

 

[Wayne Morgan]

Yes, you can. You may want to try the wizard one time though to see what it
looks like.

1) Use only a Detail section (not required, but it becomes more
complicated). Make the detail section the same size as a single label and
set Can Shrink and Can Grow for the section to No.

2) Place the controls you need on the report.

3) Go to Page Setup in the File menu. Set the margins to match the spacing
between the edge of the sheet and the outside edge of the labels.

4) On the Columns tab, The Column Size should be "Same as Detail". Set the
"Number of Columns" to the number of columns of labels on the sheet. Set the
"Row Spacing" to the distance between successive rows of labels and the
"Column Spacing" to the distance between successive columns of labels.
Choose "Down, then Across" or "Across, then Down" as desired. Usually,
"Across, then Down" would be used for labels.

 

[Wayne Morgan]

I don't have a sheet of 5963 here to see what the sizes are, but those
margins seem a little large. Is there really .55" & .68" between the edge of
the paper and the start of the first label? If I create a sheet of these
labels in Word, Word shows the margins should be

Top 0.5"
Bottom 0"
Left 0.16"
Right 0.16"

Other settings:
Column Spacing 0.19"
Row Spacing 0"
Column Count 2
Detail Size 4" wide, 2" tall

--
Wayne Morgan
Microsoft Access MVP

Little Confused: Labels are 2" * 4"
Margins are Top 0.55
Bottom 0.55
Right 0.683
Left 0.683
2 Columns
Row spacing 0.1825
Column spacing 0.375
Width 4"
Height 2"

Using the following code.
Customers
Address
=Trim([City] & ", " & [Region] & " " & [Postal Code])

Is there a way that I can make access print my labels without using the
wizard?
Report name is RLabels
Using Template Avery 5963

 

[Dave Elliott]

Just about got it; But only printing (4) rows instead of (5), what can i
change?
Number of Columns 3
Row Spacing 0.1875
Column Spacing 0.375
4" 2"
Top .55
Bottom .55
Left 0.677
Right 0.677

I don't have a sheet of 5963 here to see what the sizes are, but those
margins seem a little large. Is there really .55" & .68" between the edge
of the paper and the start of the first label? If I create a sheet of these
labels in Word, Word shows the margins should be

Top 0.5"
Bottom 0"
Left 0.16"
Right 0.16"

Other settings:
Column Spacing 0.19"
Row Spacing 0"
Column Count 2
Detail Size 4" wide, 2" tall

--
Wayne Morgan
Microsoft Access MVP

Little Confused: Labels are 2" * 4"
Margins are Top 0.55
Bottom 0.55
Right 0.683
Left 0.683
2 Columns
Row spacing 0.1825
Column spacing 0.375
Width 4"
Height 2"

Using the following code.
Customers
Address
=Trim([City] & ", " & [Region] & " " & [Postal Code])

Is there a way that I can make access print my labels without using the
wizard?
Report name is RLabels
Using Template Avery 5963

 

[Wayne Morgan]

Again, I believe the margins (left, right, and bottom) are too large. Also,
you are show 3 columns, I believe the 5963 has 2 columns. If the labels are
4" wide and the paper is 8.5"x11", there isn't room for 3 columns.

--
Wayne Morgan
Microsoft Access MVP

Just about got it; But only printing (4) rows instead of (5), what can i
change?
Number of Columns 3
Row Spacing 0.1875
Column Spacing 0.375
4" 2"
Top .55
Bottom .55
Left 0.677
Right 0.677

I don't have a sheet of 5963 here to see what the sizes are, but those
margins seem a little large. Is there really .55" & .68" between the edge
of the paper and the start of the first label? If I create a sheet of
these labels in Word, Word shows the margins should be

Top 0.5"
Bottom 0"
Left 0.16"
Right 0.16"

Other settings:
Column Spacing 0.19"
Row Spacing 0"
Column Count 2
Detail Size 4" wide, 2" tall

--
Wayne Morgan
Microsoft Access MVP

Little Confused: Labels are 2" * 4"
Margins are Top 0.55
Bottom 0.55
Right 0.683
Left 0.683
2 Columns
Row spacing 0.1825
Column spacing 0.375
Width 4"
Height 2"

Using the following code.
Customers
Address
=Trim([City] & ", " & [Region] & " " & [Postal Code])




Is there a way that I can make access print my labels without using the
wizard?
Report name is RLabels
Using Template Avery 5963