Can grow

[saintedmunds]

Hello

Im sorry if this goes on a bit but will explain as best I can.

I have a report which is grouped by Month and Week when i use can grow in the detail section it works but when i then show a week footer so i can put a line on it the can grow doesnt work any more.

also i need the folowing to happen in either the month header or week header i need it to show:
April Week1
but then on the next section as the month hasnt changed i would like it to show just:
Week2
and only show the month when it changes.

Any ideas would be great

 

[dhookom]

Can grow in your detail section should always work as long as the control and section can grow.

You can create a Month header and Week header of the same exact height. Then add code to the On Format event of the Month header

    Me.MoveLayout = False

This will overlay the month header on top of the following week header.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]