Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Vail, Colorado, USA
    Posts
    173
    Thanks
    27
    Thanked 0 Times in 0 Posts

    Set properties of report sections using VBA

    My reports is built dynamically as the columns can change . everything seems to be working OK but I would like to be able to set the height of Headers, Footers as the report is built and I have not been able to find a way to do that. Any suggestions greatly appreciated.

    Thanks

    peter

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Lounger
    Join Date
    Feb 2011
    Posts
    43
    Thanks
    0
    Thanked 6 Times in 6 Posts
    I haven't tried it but how about setting the height of a hidden rectangle.

  4. The Following User Says Thank You to Cronk For This Useful Post:

    mitchbvi (2013-07-18)

  5. #3
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Vail, Colorado, USA
    Posts
    173
    Thanks
    27
    Thanked 0 Times in 0 Posts
    WIll try that it should work as long as I have shrink grow turned on. Seems like it should be easier than that, Thanks for you time.

  6. #4
    2 Star Lounger HiTechCoach's Avatar
    Join Date
    Sep 2011
    Location
    Oklahoma City, OK
    Posts
    162
    Thanks
    0
    Thanked 24 Times in 24 Posts
    Note: Building reports dynamically with VBA code is not commonly done. It does require a lot of work.

    Most people deploy their front end as an mde/accde which prevents you from being able to build reports dynamically. I hae a crosstab report that can vary in the number of columns. I do not have to modify the report design at runtime to handle this. This allows me to lock it down as an mde/accde. See: Dynamic Report based on a Crosstab query
    Boyd Trimmell aka HiTechCoach (Access Information here)
    Microsoft MVP - Access Expert
    "If technology doesn't work for people, then it doesn't work."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •