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.

--
Duane Hookom
Microsoft Access MVP


"M Skabialka" wrote:

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" wrote in message
...
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?

--
Duane Hookom
Microsoft Access MVP


"M Skabialka" wrote:

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" wrote in message
...
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.

--
Duane Hookom
Microsoft Access MVP


"M Skabialka" wrote:

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