Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1

    Unanswered: Report control formatting.

    I have a report with multiple text controls, each set to auto-grow. I want the end result to look like a spreadsheet with all the cells in a row being the same height.

    How can I achieve this effect?

    I've tried putting borders on all the cells and then setting their heights in the onformat and onretreat events, but Access does not seem to know the height to which it has set the row after growing the controls.

    I've also tried removing control borders and adding verticle lines in the detail section, but I run into the same problem trying to dynamically set the lines' heights.

    Is there another (any) way to do this?

    Thanks.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    No, not really.

    Once a row has been printed, you can't alter any of it's attributes. Since Access has no clue how large the "biggest" field is going to be until it starts cycling through the records, it can't make them all the same size.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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