Grow field in report footer?

Rowena

Registered User.
Local time
Today, 01:39
Joined
Jul 16, 2002
Messages
27
Greetings,
I have a report that has quite a bit of information printing in the page footer. I have a field to show "directions to jobsite" and sometimes it may take up several lines, while other times it may be blank. I have noticed that when I print the report and that particular field is larger than a couple of lines, it pushes the other fields in the footer off the bottom of the page.

Is there a way to make the footer "grow" upwards so that none of the info is lost?

I don't know if this makes sense - let me know if it doesn't!

thanks in advance,

Rowena
 
You can either:
-resize the footer by setting its height at run-time Me.section(acPageFooter).Height = ... (in twips)
-or at the contrary force the last detail section to the next page when you detect that: the page total height - total heights of (details sections + footers + headers) is not sufficient.

The latter method is the one used to avoid situations where n detail sections would fit on a given page but n+1 would end on the next page. You will find code sample for that in access help and the MS report sample database.
 
Last edited:
Thanks for the reply, Alexandre.

The footer needs to be complete on each page of the report, so forcing it to print on the next page will not work here.

At the risk of sounding thick, I don't really understand how to do the other. I know that twips are the units of measurement for text, but I have no idea how to implement your idea.

Can you rephrase it for a total neophyte (me)? :confused:

Thanks so much!

Rowena
 
For anyone who is interested, I did a quick fix by simply increasing the size of the footer.

I'd still like to be able to make it resize itself automatically, though.

Thanks anyway.

Rowena.
 
I guess that some of the limitation of Access report formatting flexibility
 

Users who are viewing this thread

Back
Top Bottom