Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Vail, Colorado, USA
    Posts
    176
    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. #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.

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

    mitchbvi (2013-07-18)

  4. #3
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Vail, Colorado, USA
    Posts
    176
    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.

  5. #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
  •