adjusting footer height

Posted on 2004-10-15
Medium Priority
Last Modified: 2008-03-06
can i  programatically adjust the footer height using visual basic?
Question by:PhillO
  • 2

Accepted Solution

StuartSanders earned 2000 total points
ID: 12326240
If you mean on a report, the report footer has a name (default is ReportFooterSection).

Within the report you can use:
 me.PageFooterSection.Height = [enter a value]

Access help isn't being nice to me at the moment, but I think that this needs to be entered in twips.  1440 = 1 inch

Expert Comment

ID: 12326241
sorry default should be PageFooterSection as I gave in the example.

Author Comment

ID: 12328011

i knew what you meant

regards phill

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

594 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question