Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / April 2008

Tip: Looking for answers? Try searching our database.

how to modify the type of label a report is using

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
yomama - 23 Apr 2008 21:21 GMT
I used the label wizard to set up name stickers which use Avery labels.  The
organization purchased Universal labels which threw off the column alignment.
How do I modify the label so the correct Universal 80107 label now
determines the page layout?  Thanks!
fredg - 23 Apr 2008 21:30 GMT
> I used the label wizard to set up name stickers which use Avery labels.  The
> organization purchased Universal labels which threw off the column alignment.
>  How do I modify the label so the correct Universal 80107 label now
> determines the page layout?  Thanks!

Doesn't the Universal 80107 box show a matching Avery number?

What's the difference between the 2 label sheets?
Just the size of the label?

If it's just the size, then very accurately measure the Universal
label's  height and width.
Open the report in design view and change the Detail height and width
to whatever the new label size is. You may need to also resize the
label controls as well.
Test it by printing out the labels on a plain piece of paper.
Hold it up against the new label sheet and see how it aligns.
Adjust as necessary.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

yomama - 23 Apr 2008 21:54 GMT
Thanks for a quick reply.  Unfortunately, the universal label box does not
indicate which Avery label it's compatible with...go figure.  Before posting
my question, I tried modifying the label size to the measured 4"x2".  If I
find the Avery equivalent to these universal labels, where do I make the
change to the label to reflect the new Avery label number?

> > I used the label wizard to set up name stickers which use Avery labels.  The
> > organization purchased Universal labels which threw off the column alignment.
[quoted text clipped - 14 lines]
> Hold it up against the new label sheet and see how it aligns.
> Adjust as necessary.
fredg - 24 Apr 2008 00:37 GMT
> Thanks for a quick reply.  Unfortunately, the universal label box does not
> indicate which Avery label it's compatible with...go figure.  Before posting
[quoted text clipped - 20 lines]
>> Hold it up against the new label sheet and see how it aligns.
>> Adjust as necessary.

The Avery Number is used by the label report wizard to set up the
column width and label height for that particular label, and to set it
to 2 or 3 (or more) columns.
The Avery Number is irrelevant once you have created the label.

If you wish to purchase Avery labels, then just create a new label
report using that Avery number when the label wizard asks for it.
Once you already have a label report set up, all you need do is change
the detail width and height as needed.
Then perhaps, modify the label controls if needed.
If more modification is necessary, in the label report design view,
click on File + Page Setup + Columns.
There you can change the number of columns, set the distance between
label columns if needed, as well as change the column width (by
unchecking the "Same as Detail" check box and entering your own column
width value).
Experiment on a copy of the label report.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.