Avery 5963

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

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
 
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.
 
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])
 
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


Dave Elliott said:
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])




Dave Elliott said:
Is there a way that I can make access print my labels without using the
wizard?
Report name is RLabels
Using Template Avery 5963
Click to expand...
Click to expand...
 
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




Wayne Morgan said:
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


Dave Elliott said:
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])




Dave Elliott said:
Is there a way that I can make access print my labels without using the
wizard?
Report name is RLabels
Using Template Avery 5963
Click to expand...
Click to expand...
Click to expand...
 
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


Dave Elliott said:
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




Wayne Morgan said:
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


Dave Elliott said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top