Increasing report detail section size

  • Thread starter Thread starter Mary
  • Start date Start date
M

Mary

I would like to omit the logo in the report page footer
section for all pages following the first. I know how to
change the size of the section in VBA, but I don't know
how to get the detail section to grow correspondingly. I
set the Can grow to Yes, but even after the reduction in
footer height, it remains the same as it is on the first
page. Any suggestions?
 
Mary-

I think you want to change the size of the Page footer, not the detail.
Make the control displaying the logo nearly zero height and Visible = No.
In the Format event of the footer, check for Page = 1 and expand the height
of the control (and make it visible) if you're on the first page.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
http://www.deanforamerica.com/site/TR?pg=personal&fr_id=1090&px=1434411
 
Ah, thanks, I was making it larger, then trying to reduce
if page>1. Will give that a try!
Mary
 
Back
Top