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

Address Label Formatting

P: n/a
Jim
I have recently looked at somebody else's access report for printing
labels. I don't understand how it manages to shuffle data about to
format the labels correctly. Any ideas would be appreciated.

The report has 6 Text boxes decending vertically down the label with
the following fields in them [Greeting], [Address1] -> [Address4] and
[Postcode].

As if by magic, if there is no data in [Address4] then [Postcode]
follows [Address3] and there is no blank field/line [Address4]. I would
have expected a blank line and then the postcode. Does anyone know how
this is working?

Best regards

Jim Grady

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


P: n/a
On 14 Sep 2004 05:16:50 -0700, "Jim" <Ji*@willow-cottage.com> wrote:

Check out the CanShrink property in the help file.
-Tom.
I have recently looked at somebody else's access report for printing
labels. I don't understand how it manages to shuffle data about to
format the labels correctly. Any ideas would be appreciated.

The report has 6 Text boxes decending vertically down the label with
the following fields in them [Greeting], [Address1] -> [Address4] and
[Postcode].

As if by magic, if there is no data in [Address4] then [Postcode]
follows [Address3] and there is no blank field/line [Address4]. I would
have expected a blank line and then the postcode. Does anyone know how
this is working?

Best regards

Jim Grady


Nov 13 '05 #2

P: n/a
"Jim" wrote
As if by magic, if there is no data
in [Address4] then [Postcode]
follows [Address3] and there is no
blank field/line [Address4]. I would
have expected a blank line and then
the postcode. Does anyone know how
this is working?


Check the CanShrink property on that Text Box. Chances are good that is is
Yes. Then check CanShrink in Help. That is exactly what it is there for --
to vertically shrink Text Boxes to fit their content; if there is no
content, it will shrink them to nothing (provided there is no other control
alongside... it can only shrink away whole lines.

Larry Linson
Microsoft Access MVP
Nov 13 '05 #3

P: n/a
Jim
Thanks guys

Jim
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.