MoveLayout and line feed question

[M Skabialka]

I have a report where several text items are drawn on one line, and to
prevent a line feed, Me.MoveLayout = False is used.
Sometimes these text items have more text, and CanGrow is set to true so
they will expand down (the width is calculated for a time line). The detail
section also has CanGrow set to true.
However the detail lines are always the same height and subsequent lines
write over text items made longer by CanGrow.

Debug.Print Me.txtName.Value & " --- " & Me.txtName.Height
shows all txtName fields to be the same height, even when they have grown.

How can I get the detail line to expand so that the text items don't
overlap?

Mich

 

[Duane Hookom]

I expect the text boxes are eventually printed over a group footer section
and the issue is the group footer section doesn't grow to match the tallest
detail section. Is that a correct assumption?

Also, you can't grab the height of a grown control until the On Print event.
The On Format will always display the design height.

 

[M Skabialka]

You were right about the On Format and On Print - I now know the height of
the taller box.
My test data draws four rows of information, the third row has a CanGrow
text box that is longer, but the 4th detail row covers the bottom part of
it.
There is no code governing the footer format - I made it smaller but it made
no difference to the detail lines..
Something must be stopping the detail section from growing.
???
Mich

 

[Duane Hookom]

I would really like to know if the contents of the detail sections is
actually being rendered in a group footer section. Change the background
color of the footer section to see if that is where all of your details are
being displayed.

Try double the height of your group footer. What happens when you do that?

 

[M Skabialka]

At first I wasn't sure what you were having me change - then realized I do
have a footer - and the MoveLayout is keeping it on the same line as the
detail, but it isn't growing as expected.

Looking through my notes I realized that this report is based on one in one
of your databases - a calendar database with various reports showing weekly
doctor appointments and rptRotation which was the basis for this report that
I am having problems with when using CanGrow on a detail field. I've had
this database since 2001, and needed a calendar based report which your
database showed great examples of.

Can you help me Grow the footer with the detail?
Thanks,
Mich

 

[Duane Hookom]

I'm not sure how to grow the group footer. On solution might be to place a
text box in the group footer that is similar to growing one in the detail
section. You would need to get the new text box to have the same width and
control source so it would grow enough to push the bottom of the group
section down.

You might try set the can grow to no and then add code to adjust the font
size to display the total value.

 

[Steve]

Hi Mich,

I don't know if this is your problem, but if any of your text items touch an
adjacent text item, your text items will not grow. To eliminate the problem,
leave a hair-width space between each of your text items.

Steve
(e-mail address removed)

 

[M Skabialka]

No, Duane was right in that it's a footer thing - I'm working on that issue.