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 / December 2005

Tip: Looking for answers? Try searching our database.

Label Reports.......

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dermot - 05 Dec 2005 13:52 GMT
Is there a way to see the outline of a label in my label report. So I can
determine how the text is positioned on each label.
It would appear to me that once the label text position is set during the
wizard, all label text position is  the same. Is there a way to change the
position of the text on each individual label.

Is there a way to modify the position of the text on each "individual label"
within the report?

I am using Labels W6.77 X H9.91 in size. two columns 8 labels per sheet.
This is a good size for me as some addresses I have are very long and have
wide titles.

The smaller addresses could be positioned
better relative to the label size if you know what I mean.

If it is not possible to adjust each individual label text position within a
report can anyone suggest an alternative method to printing labels.
Thanks in Advance.
Duane Hookom - 05 Dec 2005 14:18 GMT
Are you aware that you can set text boxes to grow and shrink? Stephen Lebans
has make it fit type code and samples at
http://www.lebans.com/makefitsingle.htm.

You can also use code in the On Format event of the detail section to set
control properties.

Signature

Duane Hookom
MS Access MVP
--

> Is there a way to see the outline of a label in my label report. So I can
> determine how the text is positioned on each label.
[quoted text clipped - 17 lines]
> report can anyone suggest an alternative method to printing labels.
> Thanks in Advance.
Dermot - 05 Dec 2005 23:36 GMT
Hi Duane
Thanks for the interesting link you sent.

I have had a look at the link Duane,
But I don't understand how it answers my question.

I have created a Contacts database.
Created a query which selects all the contacts the have a true criteria
agains a field called "Card".
I then created a label report based on the query using the query wizard.
My question
Can I change the text position on each label individually? It seems to me
that I have no way do doing this once the report has been created.

If I have misunderstood your answer, sorry....could you please clarify.
Regards
Dermot

> Are you aware that you can set text boxes to grow and shrink? Stephen Lebans
> has make it fit type code and samples at
[quoted text clipped - 24 lines]
> > report can anyone suggest an alternative method to printing labels.
> > Thanks in Advance.
Duane Hookom - 06 Dec 2005 03:37 GMT
The text box position can be changed for each record individually by adding
code in the On Format event of the detail section. Maybe you need to give an
example of what you would like to move and what the conditions are that
would require the control to move.

Signature

Duane Hookom
MS Access MVP

> Hi Duane
> Thanks for the interesting link you sent.
[quoted text clipped - 49 lines]
>> > report can anyone suggest an alternative method to printing labels.
>> > Thanks in Advance.
 
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.