Labels 11 Vertical Issue

[John Baker]

Hi:

I have a user who has labels that are set up 3 across and 11 vertical (which is unusual at
best), and he wants me to print names and addresses on them. I have already set up for
labels 10 vertical and 3 across (Avery 5160)which are another standard the user has, but
can't find any in the setup for labels that show 11 vertical. I am therefore using the
Avery 5160 as a start, and modifying the top and bottom margins (the margins on the 11
vertical are .079 at the top and bottom). Using the "Page Setup" for the labels I have
reduced the top margin to .079, but the BOTTOM margin refuses to accept .079 and reverts
to 0.46 all the time. Does anyone have a suggestion as to how I can either: (a) reduce the
bottom margin to 0.079 OR (b) get 11 vertical by some other means?

Thanks in advance
John Baker

[Douglas J. Steele]

Most printers have a limitation as to how small the margin can be. You may
have to use a different printer in order to be able to reduce the margin
sufficiently.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"John Baker" <Ba******@Verizon.net> wrote in message
news:lm********************************@4ax.com...

Hi:

I have a user who has labels that are set up 3 across and 11 vertical (which is unusual at best), and he wants me to print names and addresses on them. I have already set up for labels 10 vertical and 3 across (Avery 5160)which are another standard the user has, but can't find any in the setup for labels that show 11 vertical. I am therefore using the Avery 5160 as a start, and modifying the top and bottom margins (the margins on the 11 vertical are .079 at the top and bottom). Using the "Page Setup" for the labels I have reduced the top margin to .079, but the BOTTOM margin refuses to accept ..079 and reverts to 0.46 all the time. Does anyone have a suggestion as to how I can either: (a) reduce the bottom margin to 0.079 OR (b) get 11 vertical by some other means?

Thanks in advance
John Baker

[John Baker]

Doug:
How do I find out for an HP 932C?

Best

John baker

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote:

Most printers have a limitation as to how small the margin can be. You may
have to use a different printer in order to be able to reduce the margin
sufficiently.

[John Baker]

Doug:

I should have mentioned at the outset that I have an application I wrote using Lotus
Approach which is set up to print the 11 down labels, and does so successfully. I am
rewriting that applications (from scratch) for Access. Hence, I don't think its the
printer defaults, since I am using the same printer with both applications.

Best

John

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote:

Most printers have a limitation as to how small the margin can be. You may
have to use a different printer in order to be able to reduce the margin
sufficiently.

[Douglas J. Steele]

Sorry: no other ideas.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"John Baker" <Ba******@Verizon.net> wrote in message
news:f7********************************@4ax.com...

Doug:

I should have mentioned at the outset that I have an application I wrote using Lotus Approach which is set up to print the 11 down labels, and does so successfully. I am rewriting that applications (from scratch) for Access. Hence, I don't think its the printer defaults, since I am using the same printer with both applications.
Best

John

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote:

Most printers have a limitation as to how small the margin can be. You mayhave to use a different printer in order to be able to reduce the margin
sufficiently.

[Rick Brandt]

"John Baker" <Ba******@Verizon.net> wrote in message
news:lt********************************@4ax.com...

Doug:
How do I find out for an HP 932C?

Change the margin to zero and then tab out. It will automatically change to the
minimum value allowed.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Phil Stanton]

Try this

Forget Access. Go to Control Panel ->Printers, Select your
printer ->Properties ->Printing Defaults ->Printing Defaults and select
Custom Paper.
Define that as the correct size for your 33 labels. (You may have to lie a
bit to accommodate the margins)

Then back to Access. Make sure that there are no Headers of footers and set
the address details on the Detail Section of the report. Ensure that
everything is Sized to Grid & aligned to Grid and that there are no
overlapping controls. The ControlSource of each control should have
=Trim(ControlName) e.g. the ControlSource of a City would be =Trim(City).
The Name of the Control must NOT be City use something like TCity
All controls must have Can Shrink & Can Grow set to yes and the same for the
Detail Section
The Detail Section vertical size is the same as the label + the separator
from the next label
The Detail Section horizontal size is the same as the label.
You can then play with the page setup using the Custom Paper as your paper.
You want 3 columns and the margins and separation as per your sheet of
labels

HTH

Phil

"John Baker" <Ba******@Verizon.net> wrote in message
news:lm********************************@4ax.com...

Hi:

I have a user who has labels that are set up 3 across and 11 vertical
(which is unusual at
best), and he wants me to print names and addresses on them. I have
already set up for
labels 10 vertical and 3 across (Avery 5160)which are another standard the
user has, but
can't find any in the setup for labels that show 11 vertical. I am
therefore using the
Avery 5160 as a start, and modifying the top and bottom margins (the
margins on the 11
vertical are .079 at the top and bottom). Using the "Page Setup" for the
labels I have
reduced the top margin to .079, but the BOTTOM margin refuses to accept
.079 and reverts
to 0.46 all the time. Does anyone have a suggestion as to how I can
either: (a) reduce the
bottom margin to 0.079 OR (b) get 11 vertical by some other means?

Thanks in advance
John Baker

[John Baker]

Phil:

Thanks for your response. Just one question: if I change the Default for the printer wont
it mess up all the other things I print.?

Best

John

"Phil Stanton" <di********@stantonfamily.co.uk> wrote:

Try this

Forget Access. Go to Control Panel ->Printers, Select your
printer ->Properties ->Printing Defaults ->Printing Defaults and select
Custom Paper.
Define that as the correct size for your 33 labels. (You may have to lie a
bit to accommodate the margins)

Then back to Access. Make sure that there are no Headers of footers and set
the address details on the Detail Section of the report. Ensure that
everything is Sized to Grid & aligned to Grid and that there are no
overlapping controls. The ControlSource of each control should have
=Trim(ControlName) e.g. the ControlSource of a City would be =Trim(City).
The Name of the Control must NOT be City use something like TCity
All controls must have Can Shrink & Can Grow set to yes and the same for the
Detail Section
The Detail Section vertical size is the same as the label + the separator
from the next label
The Detail Section horizontal size is the same as the label.
You can then play with the page setup using the Custom Paper as your paper.
You want 3 columns and the margins and separation as per your sheet of
labels

HTH

Phil

"John Baker" <Ba******@Verizon.net> wrote in message
news:lm********************************@4ax.com.. .

Hi:

I have a user who has labels that are set up 3 across and 11 vertical
(which is unusual at
best), and he wants me to print names and addresses on them. I have
already set up for
labels 10 vertical and 3 across (Avery 5160)which are another standard the
user has, but
can't find any in the setup for labels that show 11 vertical. I am
therefore using the
Avery 5160 as a start, and modifying the top and bottom margins (the
margins on the 11
vertical are .079 at the top and bottom). Using the "Page Setup" for the
labels I have
reduced the top margin to .079, but the BOTTOM margin refuses to accept
.079 and reverts
to 0.46 all the time. Does anyone have a suggestion as to how I can
either: (a) reduce the
bottom margin to 0.079 OR (b) get 11 vertical by some other means?

Thanks in advance
John Baker

[John Baker]

Rick:

In the page setup control it wont accept zero or aything lower than .46". I am not quite
clear how I execute your suggestion.

Best

John

"Rick Brandt" <ri*********@hotmail.com> wrote:

"John Baker" <Ba******@Verizon.net> wrote in message
news:lt********************************@4ax.com.. .

Doug:
How do I find out for an HP 932C?

Change the margin to zero and then tab out. It will automatically change to the
minimum value allowed.

[Douglas J. Steele]

Can you create another Printer definition strictly for the new paper size?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"John Baker" <Ba******@Verizon.net> wrote in message
news:70********************************@4ax.com...

Phil:

Thanks for your response. Just one question: if I change the Default for the printer wont it mess up all the other things I print.?

Best

John

"Phil Stanton" <di********@stantonfamily.co.uk> wrote:

Try this

Forget Access. Go to Control Panel ->Printers, Select your
printer ->Properties ->Printing Defaults ->Printing Defaults and select
Custom Paper.
Define that as the correct size for your 33 labels. (You may have to lie abit to accommodate the margins)

Then back to Access. Make sure that there are no Headers of footers and setthe address details on the Detail Section of the report. Ensure that
everything is Sized to Grid & aligned to Grid and that there are no
overlapping controls. The ControlSource of each control should have
=Trim(ControlName) e.g. the ControlSource of a City would be =Trim(City).
The Name of the Control must NOT be City use something like TCity
All controls must have Can Shrink & Can Grow set to yes and the same for theDetail Section
The Detail Section vertical size is the same as the label + the separator
from the next label
The Detail Section horizontal size is the same as the label.
You can then play with the page setup using the Custom Paper as your paper.You want 3 columns and the margins and separation as per your sheet of
labels

HTH

Phil

"John Baker" <Ba******@Verizon.net> wrote in message
news:lm********************************@4ax.com.. .

Hi:

I have a user who has labels that are set up 3 across and 11 vertical
(which is unusual at
best), and he wants me to print names and addresses on them. I have
already set up for
labels 10 vertical and 3 across (Avery 5160)which are another standard the user has, but
can't find any in the setup for labels that show 11 vertical. I am
therefore using the
Avery 5160 as a start, and modifying the top and bottom margins (the
margins on the 11
vertical are .079 at the top and bottom). Using the "Page Setup" for the labels I have
reduced the top margin to .079, but the BOTTOM margin refuses to accept
.079 and reverts
to 0.46 all the time. Does anyone have a suggestion as to how I can
either: (a) reduce the
bottom margin to 0.079 OR (b) get 11 vertical by some other means?

Thanks in advance
John Baker

[Phil Stanton]

It only affects custom size paper.
Do you use Custom size paper for anything else, if so you may be able to set
up a second printer for the HP 932C, but call it by another name.

Phil

"John Baker" <Ba******@Verizon.net> wrote in message
news:70********************************@4ax.com...

Phil:

Thanks for your response. Just one question: if I change the Default for
the printer wont
it mess up all the other things I print.?

Best

John

"Phil Stanton" <di********@stantonfamily.co.uk> wrote:

Try this

Forget Access. Go to Control Panel ->Printers, Select your
printer ->Properties ->Printing Defaults ->Printing Defaults and select
Custom Paper.
Define that as the correct size for your 33 labels. (You may have to lie a
bit to accommodate the margins)

Then back to Access. Make sure that there are no Headers of footers and
set
the address details on the Detail Section of the report. Ensure that
everything is Sized to Grid & aligned to Grid and that there are no
overlapping controls. The ControlSource of each control should have
=Trim(ControlName) e.g. the ControlSource of a City would be =Trim(City).
The Name of the Control must NOT be City use something like TCity
All controls must have Can Shrink & Can Grow set to yes and the same for
the
Detail Section
The Detail Section vertical size is the same as the label + the separator
from the next label
The Detail Section horizontal size is the same as the label.
You can then play with the page setup using the Custom Paper as your
paper.
You want 3 columns and the margins and separation as per your sheet of
labels

HTH

Phil

"John Baker" <Ba******@Verizon.net> wrote in message
news:lm********************************@4ax.com. ..

Hi:

I have a user who has labels that are set up 3 across and 11 vertical
(which is unusual at
best), and he wants me to print names and addresses on them. I have
already set up for
labels 10 vertical and 3 across (Avery 5160)which are another standard
the
user has, but
can't find any in the setup for labels that show 11 vertical. I am
therefore using the
Avery 5160 as a start, and modifying the top and bottom margins (the
margins on the 11
vertical are .079 at the top and bottom). Using the "Page Setup" for
the
labels I have
reduced the top margin to .079, but the BOTTOM margin refuses to accept
.079 and reverts
to 0.46 all the time. Does anyone have a suggestion as to how I can
either: (a) reduce the
bottom margin to 0.079 OR (b) get 11 vertical by some other means?

Thanks in advance
John Baker