Report, Repeat the group footer

[Biju George]

Hi

I have a report in which the detail section of the report have one record or
5 + records. IF the number of records are more, then the report fills the
complete page, but if only one or two records are there in Detail section of
the report then there is empty space between the detail section and Page
footer section. I want to fill this empty space with rows and coloum (table
created with the help of lines) when the number of records are 1 or 2.

I put the rows and coloums(table created with the help of lines) in the
group footer it is okay however when the number of records in detail section
is more than 4+ then this goes to next page which is not required. Is there
any way to hide the group footer or repeat the group footer accordingly to
the number of records.

Thanks for the help.

Using Access 2003.

Regards
Biju Kuwait

 

[Guest]

Hi

Seems a bit over the top. You could just set the Can Grow / Can Shrink to =
Yes

But if you want lines in the empty space you "could" put 3 unbound text
boxes (one above each other) in the form footer above anything you already
have in the footer.



Use this as the countrol source for the text boxes
IIf (Count( [FieldName]<3) , String(150,"_")
IIf (Count( [FieldName]<4) , String(150,"_")
IIf (Count( [FieldName]<5) , String(150,"_")

Of course change the FieldName and the string length to suit.