Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009
    Location
    Up Nort' Wi
    Posts
    140

    Unanswered: Setting dynamic report detail height using vba

    Good morning,

    Ok, brick wall number 487 this week<g> I've got a dynamic report function (parts of it I ganked off the web) that I've almost got perfect for my needs...except for the life of me I can't figure out how to set a detail size. Some reports look fine, but, other reports, that are pulling less fields, look terrible with huge amounts of white space between the groups.

    I tried looking for a .detail within the report, but, cannot find it. Any time I try to change the cangrow/canshrink it throws errors.

    Any thoughts? (Other than take it as it is<g>)

    Thanks,

    Sam, been a really long short week
    Good, fast, cheap...Pick 2.

  2. #2
    Join Date
    Aug 2009
    Location
    Up Nort' Wi
    Posts
    140
    Woohoo! Finally figured it out. For future posterity I was missing a required argument on the .section call.

    Was putting in "rpt.section.height = 200"
    When what I needed was "rpt.section(acDetail).height = 200"

    Seems so obvious in hindsight. Ahh well, maybe this'll help someone else down the road.

    Sam, is it time to go home yet??
    Good, fast, cheap...Pick 2.

Posting Permissions

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