Can Grow and Control Position Problem

[Frederick Wilson]

Hello all,

I am sure this is normal for Access Reports but it is driving me nuts.

On my report I have several text fields along the left side. On the
right side I have a subreport.

All controls can grow = yes.

When the subreport control grows it throws everything out of alignment
and some of the controls on the left side do not display all their data.

Is this normal?
Is there a way around it?

If I set the subreport control can grow = no everything on the left side
of the report looks great but I do not get everything in the subreport.

Any ideas?

Thanks,
Fred

 

[Marshall Barton]

I am sure this is normal for Access Reports but it is driving me nuts.

On my report I have several text fields along the left side. On the
right side I have a subreport.

All controls can grow = yes.

When the subreport control grows it throws everything out of alignment
and some of the controls on the left side do not display all their data.

Is this normal?
Is there a way around it?

If I set the subreport control can grow = no everything on the left side
of the report looks great but I do not get everything in the subreport.

Any controls that have their Top below the bottom of a
CanGrow control will be pushed down the page.

Try making the subreport control tall enough that its bottom
is below the top of all the text boxes you don't want to be
pushed down the page. Set the subreport's CanShrink
property to Yes so it won't take up space that's not needed.

 

[Fred Wilson]

If it is that easy I am going to be mighty upset with myself. I
struggled and struggled with this thing just about all day Friday. I'll
check it out on Tuesday. If it applies, have a grand holiday weekend.

Fred

 

[Frederick Wilson]

This did not work. I set all controls that were side by side to CanGrow
and CanShrink. Additionally, I set the detail section to CanGrow and Can
Shrink.

Although the controls did not move around the bottom controls did not
show all their data.

In design view, I stretched out the detail section about an inch and
half below the lowest control and was able to get everything to show but

 

[Marshall Barton]

I don't understand what you're describing. Could you
provide more details about where the controls are located,
their behavior and what you want?

 

[Frederick Wilson]

The report detail section is 6" wide and has the following

On the left half of the report are four controls

txtCommo 2" wide, CanGrow=Yes, CanShrink=Yes
txtAddFac 2" wide, CanGrow=Yes, CanShrink=Yes
txtDocs 2" wide, CanGrow=Yes, CanShrink=Yes
txtLoc 2" wide, CanGrow=Yes, CanShrink=Yes

On the Right half of the report I have one subReport Control
srptCapability 3.75" wide, CanGrow=Yes, CanShrink=Yes

The top of srptCapability is in line with the top of txtCommo

There is about 0.10" space between each of the controls on the left.

In design mode, I have manually stretched srptCapability control to be
below txtLoc. However, in runtime when the srptCapability control grows
I usually can not see anything in the txtDocs or txtLoc control.
Sometimes I can see only part of what is in txtDocs and never anything
in txtLoc.

Hope this explains it.

 

[Marshall Barton]

The only way I can get that sort of result (AXP) is if the
detail section's CanGrow property is set to No.

I haven't test your scenario is other versions so I won't
swear that they'll behave the same. What version are you
using?

 

[Fred Wilson]

Access 2000.

You bring up a good point. I might just bring it home and see how it
reacts on AXP.

For now I've reorganized the form so it doesn't cause me problems but it
sure doesn't look as good as the other way.

Thanks,
Fred