Results 1 to 2 of 2

Thread: Automatically define column width of MsFlexGrid

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Apr 2016
    Posts
    27

    Automatically define column width of MsFlexGrid

    Hi

    How to Automatically define column width of MsFlexGrid . Page Size is A4.

    Column Width should get automatically assigned according to no of columns .

    Total width should be according to A4 size exclusing some margins for Left & Right


    Thanks

  2. #2
    PowerPoster
    Join Date
    Feb 2006
    Posts
    22,976

    Re: Automatically define column width of MsFlexGrid

    Printing forms is almost never a good idea.

    Save yourself a ton a grief: use a DataReport for tabular reporting. You can always report based on a fabricated Recordset if you don't have a database query to report. If DataReports are not flexible enough then bite the bullet and do your own formatting, printing, and pagination.


    Even if you insist on running down this "print form" rabbit hole before realizing how awful it is, there is no magic for sizing FlexGrid columns. You'll just have to do the math. Of course most of the time just making all columns the same width isn't viable because some would have narrow content compared to others. You also need to take the width of header row columns into account.

Posting Permissions

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



Click Here to Expand Forum to Full Width