Solved

adjusting footer height

Posted on 2004-10-15
3
345 Views
Last Modified: 2008-03-06
can i  programatically adjust the footer height using visual basic?
0
Comment
Question by:PhillO
  • 2
3 Comments
 
LVL 3

Accepted Solution

by:
StuartSanders earned 500 total points
Comment Utility
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
0
 
LVL 3

Expert Comment

by:StuartSanders
Comment Utility
sorry default should be PageFooterSection as I gave in the example.
0
 

Author Comment

by:PhillO
Comment Utility
thanks

i knew what you meant

regards phill
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

772 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now