By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,083 Members | 2,237 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,083 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
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(address2),city,address2)
=iif(isnull(address2),"",city)

Hope that makes sense
Pachydermitis
Nov 13 '05 #3

P: n/a
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

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.