Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2006
    Posts
    3

    How-to adjust all row heights to expand the same amount?

    First question - does the search function not work in this forum? I search for simple words like "row" or "height" and received 0 results.

    -------------------------------------------------------------------
    Second Question - Using just the "Can Grow" property for row textboxes in a tabular report will create a jagged looking report. Some textboxes will be 2 or 3 times the height of the textbox next to it.



    So I came up with an OnFormat function that counts the number of characters in each textbox, and dividing this number (and a constant) by the column width of each textbox - will save the largest number as a max-row-height variable, which on a second pass will go back and adjust all textbox heights to this number.

    The problem is a disproportionate number of uppercase letters vs lowercase letters can throw this off.


    Is there a better way of doing this?

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    You could try using a font like Courier in which all characters inhabit the same area of space on the page. That should allow your basic approach to still work...

  3. #3
    Matrix's Avatar
    Matrix is online now Admin
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2005
    Posts
    517

    Re: How-to adjust all row heights to expand the same amount?

    [quote="egads"]First question - does the search function not work in this forum? I search for simple words like "row" or "height" and received 0 results.

    You are right, this forum uses Google search which worked very well, but Google has many problems in the past a few months, many websites/pages were de-indexed.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 10
    Last Post: 11-13-2006, 02:07 AM
  2. Replies: 2
    Last Post: 11-09-2005, 02:51 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums