Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2009
    Posts
    2

    Unanswered: Report text boxes

    I have a report where the end result I really want it to look like a basic excel spreadsheet output. Each record has different heights to them do to a memo field that is sometimes large, sometimes small. Is there a way to get all the other text boxes to grow to the maximum height of that record?

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Never tried it, but you might like to try setting the Height property of the text boxes to the height of the memo field using VBA in the OnFormat of the detail section.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Oct 2009
    Posts
    2
    I'm not much of a MS Access guru. Don't know how to set up VB in Access. I'm more of an Excel guru. Problem with Excel is that it maxes out on word wrap. Need Access so I can get the whole text of these large fields.

Posting Permissions

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