labels

[Joan]

I am using access 2003. I have been printing creating a
printing lables since access95 with no problem. Now using
avery 8160 mailing label definition, I can only print 27
labels to a page. I cannot get 30 to print. Does any one
have any ideas. I have just used the wizard to create
them.

Thanks Joan

 

[fredg]

I am using access 2003. I have been printing creating a
printing lables since access95 with no problem. Now using
avery 8160 mailing label definition, I can only print 27
labels to a page. I cannot get 30 to print. Does any one
have any ideas. I have just used the wizard to create
them.

Thanks Joan

Modern printers have a minimum no print zone on all margins, left,
right, top, and bottom.

The length of the detail section for that last row of labels is just a
tad to much for your printer.

Here are some trial and error things you can do to perhaps resolve
this difficulty (or perhaps not):

1) Make sure the bottom margin for the label report is small enough.
Set it to 0" in File + Page SetUp.
When you save the change, it will be reset to the printer minimum.

2) Slightly move the label position a bit higher on the detail
section, so the top line prints nearer the top of the label.

3) Replace all the label controls you now have with just 1 text
control, sized just a shade less than the maximum height that will fit
in the Detail space available.
Name this new control [CombinedAddress]
Set it's Control Source to:
= [FirstName] & " " & [LastName] & Chr(13) & Chr(10) & [Address] &
Chr(13) & Chr(10) & [City] & ", " & [State] & " " & [Zip]

(Change the field names above, as needed.)
The above has the advantage of spacing each line slightly
closer than using individual text boxes.
Preview the report.
If necessary, go back to design view and make the label
height smaller, (from the bottom) until you get that last label row to
show.

4) Make the Font size smaller so that you can make the above text
control height smaller.

 

[Guest]

Fred
I guess I am a little confused. I have an hp deskjet1000c (old printer). I
never had a problem with the printer before I went to access2003. I can
print the last set of labels if I am using Avery through Word. Just not
Access. Labels I converted from 2000 no longer work
Access will not let me set bottom margin to 0. .565 is the smallest. As
far a smaller font, I am already using 8. That's about as small as I would
want a label. I will try resetting the control source because currently I am
using 3 text boxes. That may work.
Thanks for you help. Joan

I am using access 2003. I have been printing creating a
printing lables since access95 with no problem. Now using
avery 8160 mailing label definition, I can only print 27
labels to a page. I cannot get 30 to print. Does any one
have any ideas. I have just used the wizard to create
them.

Thanks Joan

Modern printers have a minimum no print zone on all margins, left,
right, top, and bottom.

The length of the detail section for that last row of labels is just a
tad to much for your printer.

Here are some trial and error things you can do to perhaps resolve
this difficulty (or perhaps not):

1) Make sure the bottom margin for the label report is small enough.
Set it to 0" in File + Page SetUp.
When you save the change, it will be reset to the printer minimum.

2) Slightly move the label position a bit higher on the detail
section, so the top line prints nearer the top of the label.

3) Replace all the label controls you now have with just 1 text
control, sized just a shade less than the maximum height that will fit
in the Detail space available.
Name this new control [CombinedAddress]
Set it's Control Source to:
= [FirstName] & " " & [LastName] & Chr(13) & Chr(10) & [Address] &
Chr(13) & Chr(10) & [City] & ", " & [State] & " " & [Zip]

(Change the field names above, as needed.)
The above has the advantage of spacing each line slightly
closer than using individual text boxes.
Preview the report.
If necessary, go back to design view and make the label
height smaller, (from the bottom) until you get that last label row to
show.

4) Make the Font size smaller so that you can make the above text
control height smaller.
--

 

[John Moore]

Joan,

Try setting the detail section of your labels report so that it cannot
expand...Can Grow = No. That has solved this type of problem for me.

TC

Fred
I guess I am a little confused. I have an hp deskjet1000c (old printer). I
never had a problem with the printer before I went to access2003. I can
print the last set of labels if I am using Avery through Word. Just not
Access. Labels I converted from 2000 no longer work
Access will not let me set bottom margin to 0. .565 is the smallest. As
far a smaller font, I am already using 8. That's about as small as I would
want a label. I will try resetting the control source because currently I am
using 3 text boxes. That may work.
Thanks for you help. Joan

I am using access 2003. I have been printing creating a
printing lables since access95 with no problem. Now using
avery 8160 mailing label definition, I can only print 27
labels to a page. I cannot get 30 to print. Does any one
have any ideas. I have just used the wizard to create
them.

Thanks Joan

Modern printers have a minimum no print zone on all margins, left,
right, top, and bottom.

The length of the detail section for that last row of labels is just a
tad to much for your printer.

Here are some trial and error things you can do to perhaps resolve
this difficulty (or perhaps not):

1) Make sure the bottom margin for the label report is small enough.
Set it to 0" in File + Page SetUp.
When you save the change, it will be reset to the printer minimum.

2) Slightly move the label position a bit higher on the detail
section, so the top line prints nearer the top of the label.

3) Replace all the label controls you now have with just 1 text
control, sized just a shade less than the maximum height that will fit
in the Detail space available.
Name this new control [CombinedAddress]
Set it's Control Source to:
= [FirstName] & " " & [LastName] & Chr(13) & Chr(10) & [Address] &
Chr(13) & Chr(10) & [City] & ", " & [State] & " " & [Zip]

(Change the field names above, as needed.)
The above has the advantage of spacing each line slightly
closer than using individual text boxes.
Preview the report.
If necessary, go back to design view and make the label
height smaller, (from the bottom) until you get that last label row to
show.

4) Make the Font size smaller so that you can make the above text
control height smaller.
--

 

[Guest]

Well, MS Word does indeed use all 30 lables on the 8160 format sheet. So the
comments about the bottom margin are not valid. I have a deskjet 952 that
has the same 1/2" bottom restriction.

Access seems not able to set itself up for the 8160 even tho it allows you
to select the 8160 as a format. It also seems to have a minimum left/right
margin of .250 whan in fact they can be 0.

How do we bring this to the attention of MS so it can be resolved?

I am using access 2003. I have been printing creating a
printing lables since access95 with no problem. Now using
avery 8160 mailing label definition, I can only print 27
labels to a page. I cannot get 30 to print. Does any one
have any ideas. I have just used the wizard to create
them.

Thanks Joan

Modern printers have a minimum no print zone on all margins, left,
right, top, and bottom.

The length of the detail section for that last row of labels is just a
tad to much for your printer.

Here are some trial and error things you can do to perhaps resolve
this difficulty (or perhaps not):

1) Make sure the bottom margin for the label report is small enough.
Set it to 0" in File + Page SetUp.
When you save the change, it will be reset to the printer minimum.

2) Slightly move the label position a bit higher on the detail
section, so the top line prints nearer the top of the label.

3) Replace all the label controls you now have with just 1 text
control, sized just a shade less than the maximum height that will fit
in the Detail space available.
Name this new control [CombinedAddress]
Set it's Control Source to:
= [FirstName] & " " & [LastName] & Chr(13) & Chr(10) & [Address] &
Chr(13) & Chr(10) & [City] & ", " & [State] & " " & [Zip]

(Change the field names above, as needed.)
The above has the advantage of spacing each line slightly
closer than using individual text boxes.
Preview the report.
If necessary, go back to design view and make the label
height smaller, (from the bottom) until you get that last label row to
show.

4) Make the Font size smaller so that you can make the above text
control height smaller.
--

 

[fredg]

Fred
I guess I am a little confused. I have an hp deskjet1000c (old printer). I
never had a problem with the printer before I went to access2003. I can
print the last set of labels if I am using Avery through Word. Just not
Access. Labels I converted from 2000 no longer work
Access will not let me set bottom margin to 0. .565 is the smallest. As
far a smaller font, I am already using 8. That's about as small as I would
want a label. I will try resetting the control source because currently I am
using 3 text boxes. That may work.
Thanks for you help. Joan

I am using access 2003. I have been printing creating a
printing lables since access95 with no problem. Now using
avery 8160 mailing label definition, I can only print 27
labels to a page. I cannot get 30 to print. Does any one
have any ideas. I have just used the wizard to create
them.

Thanks Joan

Modern printers have a minimum no print zone on all margins, left,
right, top, and bottom.

The length of the detail section for that last row of labels is just a
tad to much for your printer.

Here are some trial and error things you can do to perhaps resolve
this difficulty (or perhaps not):

1) Make sure the bottom margin for the label report is small enough.
Set it to 0" in File + Page SetUp.
When you save the change, it will be reset to the printer minimum.

2) Slightly move the label position a bit higher on the detail
section, so the top line prints nearer the top of the label.

3) Replace all the label controls you now have with just 1 text
control, sized just a shade less than the maximum height that will fit
in the Detail space available.
Name this new control [CombinedAddress]
Set it's Control Source to:
= [FirstName] & " " & [LastName] & Chr(13) & Chr(10) & [Address] &
Chr(13) & Chr(10) & [City] & ", " & [State] & " " & [Zip]

(Change the field names above, as needed.)
The above has the advantage of spacing each line slightly
closer than using individual text boxes.
Preview the report.
If necessary, go back to design view and make the label
height smaller, (from the bottom) until you get that last label row to
show.

4) Make the Font size smaller so that you can make the above text
control height smaller.
--

Check the default Access print margin settings in
Tools + Options + General.
Is there a default value there?
Set them all to 0".
Does that help?

 

[Guest]

Close, but no cigar.

Setting the tools/options/general print margins to 0L,0R,0T,.5B helps but is
also necessary to set the file/page setup/ page margins. However thay cannot
be set to less than .066T,.506B,.25L, .25R. Then you will get 30 labels on a
page, BUT they wont be aligned with the labels on the actual labels. Setting
the top margin to .5 will make the alignment ok, but then you loose the
bottom row of labels.

However a value of .489 for the top margin results in 30 labels per page AND
an acceptable alignment.

The Access developer needs to have lunch with the Word developer and learn
the secrets of printer setup. ;-)

Fred
I guess I am a little confused. I have an hp deskjet1000c (old printer). I
never had a problem with the printer before I went to access2003. I can
print the last set of labels if I am using Avery through Word. Just not
Access. Labels I converted from 2000 no longer work
Access will not let me set bottom margin to 0. .565 is the smallest. As
far a smaller font, I am already using 8. That's about as small as I would
want a label. I will try resetting the control source because currently I am
using 3 text boxes. That may work.
Thanks for you help. Joan

On Mon, 17 Jan 2005 15:35:19 -0800, Joan wrote:

I am using access 2003. I have been printing creating a
printing lables since access95 with no problem. Now using
avery 8160 mailing label definition, I can only print 27
labels to a page. I cannot get 30 to print. Does any one
have any ideas. I have just used the wizard to create
them.

Thanks Joan

Modern printers have a minimum no print zone on all margins, left,
right, top, and bottom.

The length of the detail section for that last row of labels is just a
tad to much for your printer.

Here are some trial and error things you can do to perhaps resolve
this difficulty (or perhaps not):

1) Make sure the bottom margin for the label report is small enough.
Set it to 0" in File + Page SetUp.
When you save the change, it will be reset to the printer minimum.

2) Slightly move the label position a bit higher on the detail
section, so the top line prints nearer the top of the label.

3) Replace all the label controls you now have with just 1 text
control, sized just a shade less than the maximum height that will fit
in the Detail space available.
Name this new control [CombinedAddress]
Set it's Control Source to:
= [FirstName] & " " & [LastName] & Chr(13) & Chr(10) & [Address] &
Chr(13) & Chr(10) & [City] & ", " & [State] & " " & [Zip]

(Change the field names above, as needed.)
The above has the advantage of spacing each line slightly
closer than using individual text boxes.
Preview the report.
If necessary, go back to design view and make the label
height smaller, (from the bottom) until you get that last label row to
show.

4) Make the Font size smaller so that you can make the above text
control height smaller.
--

Check the default Access print margin settings in
Tools + Options + General.
Is there a default value there?
Set them all to 0".
Does that help?