canGrow on text fields - don't want to change size of report though.

[Not Me]

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

[Galina]

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

[Pachydermitis]

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

First make the fields not grow. Then put conditions in some of the
controls - for example.

Name
address1
=iif(isnull(add ress2),city,add ress2)
=iif(isnull(add ress2),"",city)

Hope that makes sense
Pachydermitis

[Phil Stanton]

Use the Wizard to create your label, nut make sure that the controls go not
overlap. Blank lines will not be printed.

Try a grid size of 4 * 4 or 5* 5 if there are too many lines for your
lable. Theb do Edit->SelectAll and then Format->SizeToGrid

Phil
"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