Field will not shrink.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frank Martin - 29 Apr 2007 02:26 GMT

I have an "address" field in a report which
sometimes contains no data.

I have set the "can grow" & "can shrink"
properties to *yes* but all I get is a blank
space on the report, whereas what I want is
for the fields to bunch up against one
another vertically.

Please help, Frank

Reply to this Message

Rick Brandt - 29 Apr 2007 02:31 GMT

> I have an "address" field in a report which
> sometimes contains no data.
[quoted text clipped - 6 lines]
>
> Please help, Frank

Are there any controls to the sides? A control will only shrink if there is
nothing next to it that does not also shrink.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

Marshall Barton - 29 Apr 2007 06:30 GMT

>I have an "address" field in a report which
>sometimes contains no data.
[quoted text clipped - 4 lines]
>for the fields to bunch up against one
>another vertically.

A control can shrink without the section shrinking. This
can be seen (as an experiment) if you set the control's
BorderStyle property to Solid or set its BackColor to
something other than white.

Rick mentioned one reason why the section might not shrink,
but another common reason is because you forgot to set the
section's CanShrink property.

Signature

Marsh
MVP [MS Access]

Reply to this Message

Frank Martin - 29 Apr 2007 23:06 GMT

Thanks for the replies.

The was a subReport next to the control in
question and which I relocated, and this
solved the problem.

But I thought that subReports were not meant
to effect the canshrink/grow property of
adjacent controls?

Is there any property in the subreport which
can effect the canshrink property?

Regards, Frank

>>I have an "address" field in a report which
>>sometimes contains no data.
[quoted text clipped - 19 lines]
> forgot to set the
> section's CanShrink property.

Reply to this Message

Marshall Barton - 29 Apr 2007 23:55 GMT

>The was a subReport next to the control in
>question and which I relocated, and this
[quoted text clipped - 3 lines]
>to effect the canshrink/grow property of
>adjacent controls?

They don't affect the property. But, the ***section*** can
not shrink unless **all** the controls in a horizontal
"band" shrink.

Perhaps another way to think about it is that can shrink
does not cause a report's controls to "move up". It causes
the section to compress empty horizontal "bands" that remain
after all the controls have shrunk.

Signature

Marsh
MVP [MS Access]

Reply to this Message

Frank Martin - 30 Apr 2007 03:23 GMT

>>The was a subReport next to the control in
>>question and which I relocated, and this
[quoted text clipped - 18 lines]
> "bands" that remain
> after all the controls have shrunk.

We live & learn.
Thanks

Reply to this Message