Labels

[Guest]

Hi, I hope you all are having a great day. I have a couple of ??? concerning
preparing/printing labels:

1) When I build my labels in a report, is there a way to tell it to wrap a
line on the label if it's too long to print on a single line? I checked
properties of the line that could possibly be too long to fit on a single
line and do not see an option that would allow me to do that.

2) Is there a way to set up a query/report that will allow me to select a
single record from the database and print a page of labels from that record?

Thanks in advance.

 

[Rick Brandt]

Hi, I hope you all are having a great day. I have a couple of ???
concerning preparing/printing labels:

1) When I build my labels in a report, is there a way to tell it to
wrap a line on the label if it's too long to print on a single line?
I checked properties of the line that could possibly be too long to
fit on a single line and do not see an option that would allow me to
do that.

Set CanGrow for that control to yes, but that will almost certainly screw up
your positioning on other labels lower on the page. When a control "grows"
everything below it is "pushed down" the page.

2) Is there a way to set up a query/report that will allow me to
select a single record from the database and print a page of labels
from that record?

You can set the criteria for the query so it only returns a single record or
(more commonly) apply a filter to the report by using the optional WHERE
argument of the OpenReport method.

DoCmd.OpenReport "ReportName",acViewPreview,,"[PrimaryKeyField] = SomeValue"

 

[Guest]

Ken,

As Rick wrote you can set the CanGrow = true and as he said that will change
the alignment for the rest of the labels. You could also set the text box's
height to the height of two lines, this will allow the data to wrap to the
given height. If you do that then the alignment on the rest of the labels
will not be off.