Chris
Report to print on an address labels should be created via Access
Report Wizard so that it fits exactly into labels layout you have.
Then, after you have a label size report in design view, draw a text
box of a size desired to contain an address. Control source of the box
will be:
=Trim([ADDRESS_LINE_1] + Chr(13) & Chr(10) + [ADDRESS_LINE_2] +
Chr(13) & Chr(10) + [ADDRESS_LINE_3] + Chr(13) & Chr(10) + ...)
Chr(13) & Chr(10) will cut your address into lines. Usage of sign "+"
will ensure that if a line of address is null, there will be no line.
You have no chance to make a report suitable to print on labels by the
way you described.
Regards.
Galina
Not Me <No***********@here.com> wrote in message news:<cj**********@ucsnew1.ncl.ac.uk>...
Hi,
I have a report, viewable in continuous form. I don't want the size of
the report to change (it should fit address labels on the printer), but
in order to minimise the space between empty fields I shrink the text
boxes, bunch them together and set cangrow to on.
E.g. instead of this:
Some name
Some address
some city
I get this:
Some name
Some address
Some city
But when I set the text fields to grow, it makes my report grow so it
won't fit the spec for the address labels.
Anyone help me here?
Cheers,
Chris