Design view arrange

[Julia82]

Hello,

I am trying to make a custom report in design view, but I want a group of
text boxes that have the OnGrow property set to yes, not to affect the bottom
one that I have put them far from them.

The thing is that in print preview, when the fields grow, I want a few
textboxes to stay in place (fixed).

Is there a possibility to do that?

Thanks!

 

[John Spencer]

You can set the section's Grow property to No even if a control's grow
property is set to yes. Access is very helpful and automatically sets the
section's grow property to Yes whenever a control's property is set to yes.

That means that after you have finished setting all the control properties in
a section of the report, you need to set the section's property back to No if
you don't want the section to grow.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[Duane Hookom]

A growing control will always "push down" controls that have a Top property
that is below the bottom of the pushing control.

 

[John Spencer]

Whoops!
I guess if you know the maximum size that you need for the control you could
try setting the control to that size and turn off the can grow property for
the control.

Otherwise, you might try putting the controls that need precise placement in a
group footer based on the primary key field or other field that can be used to
determine each record change in the detail section. If you turn off can grow
on the detail section this might work for you.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[Julia82]

Hei, thanks all for the pointers

The only thing that worked was to put all the growing controls in header and
the rest in the details section, but I don't want to do that because I can't
print my report like this... I need the header.

I somehow rearranged the page on one column only, that way didn't affect the
pagination and the design...

Thanks all for the help.

 

[John Spencer]

You need to ADD a new group to the report using the grouping and sorting
dialog. And add a footer that will appear under the detail section for every
detail section you print.

If your records are sorted by some fields, you can often add a group at the
bottom of the sort based on the primary key field and use that to force a
break after the detail. Then you can use the group footer of this new section
to hold your controls that need to be in a specific position relative to the
controls in the details section.


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County