Eliminating so much "row" space between items in a report?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

StargateFan - 03 Jan 2006 13:39 GMT

I have the concatenated fields coded with Trim() and with cangrow and
canshrink set to yes. I've experimented with the placement of the
field boxes and they're touching each other top to bottom. That might
be considered overlapping but it seems to work and when I even moved
apart by one unit using Ctrl+arrow, I just got space between fields so
I have a feeling the overlap isn't creating this problem. Placement
of report on page seems okay, too.

The problem is that in the report, there is way too much space between
records. Is there any solution to this?

Thank you! :oD

Reply to this Message

Ken Snell (MVP) - 03 Jan 2006 14:01 GMT

For CanGrow and CanShrink to work, the controls cannot be touching in the
vertical direction -- there must be at least a pixel of space between them.
And also be sure to set the CanGrow and CanShrink properties of the section
in which the controls are located.

Signature

Ken Snell
<MS ACCESS MVP>

>I have the concatenated fields coded with Trim() and with cangrow and
> canshrink set to yes. I've experimented with the placement of the
[quoted text clipped - 8 lines]
>
> Thank you! :oD

Reply to this Message

StargateFanFromWork - 03 Jan 2006 23:58 GMT

> For CanGrow and CanShrink to work, the controls cannot be touching in the
> vertical direction -- there must be at least a pixel of space between them.
> And also be sure to set the CanGrow and CanShrink properties of the section
> in which the controls are located.

Ah, it was the section that was missing the CanShrink. Once I set it to
CanShrink, too, problem fixed! <g>

Thanks!

> Ken Snell
> <MS ACCESS MVP>
[quoted text clipped - 11 lines]
> >
> > Thank you! :oD

Reply to this Message