Hi. I’m looking for a way to populate a listbox. The number of records will vary from as little as 10 and up to hundreds. I want the number of rows to be limited to 25, and then the next column would contain the next 25 records.
Say the number of records is 60. I would calculate the number of columns to be 3:
LBColCount = (data.RecordCount / 25) + 1
I want the first column to be records 1 to 25, the second column to be records 25 to 50, and the third would be 51 to 60 (there would be some empty fields in the last column, and I am ok with this)
How can this be set up to choose the first 25, the next 25, and so on? I’m getting the records from a database and then appending to an array. I just cannot figure out how to select x amount and then move onto the next amount without the array going out of bounds.
This is ultimately going to be used to create a PDF table using MBS DynaPDF. I already have the function to make a PDF table, but the problem is the report would be several pages long with a source of 100+ records, and I wanted to try and get them all onto one page if possible. If anyone has a better solution (possibly not even using a listbox and PDF table) for the report, please advise.