blank records and page footers

[kkson]

I need to fill out a report with blank records that will fill up the last page of the report down to the page footer. Also, the first page of the report will have a 5 line page footer. all the other pages will have a 1 line footer. I can get the 5 line page footer to show on page 1 only and the 1 line footer to show on all other pages. But I need the page footer to shrink in size. The 5 lines leave a space when I use the 1 line footer. I have set the can grow and shrink to 'yes' but it still leaves a space.

 

[dhookom]

Page Header and Footer sections do not grow or shrink.

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]

 

[kkson]

is there a way to size them in vba? thats right they don't, sorry i was trying subreports and i had them to grow and shrink.

 

[dhookom]

The only way to size Page sections in code is to open the report in design view and set them. This isn't very useful since you want the sizes to vary.

There is a KB article

http://support.microsoft.com/kb/208979/en-us

"How to Print a Group Footer at a Specific Location" that might be of help.

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]

 

[kkson]

is there a way to assign items to a page footer? say if its page 1 use this footer or subreport else use this footer or subreport. dynamically assign an item to the footer.

thanks

 

[dhookom]

You can show or hide items in page footers based on the page number. You would need to have a Page of Pages somewhere in the report. You can then use code like:

If Me.Page = 1 Then

  Else

End If

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]