FlexGrid Longer

Hi, thanks alot..

If I have a 1 column and like 10 rows the code you posted will it work with my modification i made on the code below.

Const thelength As Integer = 2000
Private Sub Form_Load()
dim i as integer

for i = 0 to eof(1)
With MSFlexGrid1
.FixedCols = 0
.Cols = 0
.Rows = i
.ColWidth(0) = thelength
End With
End Sub

Hi Cimperiali, thanks for the code it sure help a lot. Is there anyway to modify your code, because let say I have 5 data files to read to the flexgrid. And each data files have different amount of records. so on the previous posted message I mention about the for loop to eof() statement and while the records it is not eof() it will continue to read the records and add flexgrid automatically to display the records contents until eof(). Is this possible?

Hey thanks alot, I'll see you sometime next week for more help if you don't mind. Much appreicated it.

To answer your first question:

There are two ways of increasing the number of rows eg for the five different files:

The first being to
Set the .ROWS property on the grid to a large number eg 9999.
keep a counter, and increment it every time you add something to the grid.
When you have finished looping through the files, set the .ROWS value of the grid to the value in your counter, if you have any fixed rows you will need to take them into account.

The second way,
is to use the .ADDITEM function. If a row doesn't exist, it will cause an error which you can trap in your error handling routine - I don't remeber the error number, but you could find it easy enough.

HTH

To set up a working example for you, I need a sample file of data you're going to use (or at least, need to know if data in files are
separated by Chr 10, Vbcrlf, commas or whatever).
Post a reply here adding a zipped data file of the kind you're
going to use.

A bit busy now. Will post something tomorrow.
Btw, from zip Form 2 is not included...

Your task is not completely clear.
I did some changes to your project. See if this can help you

Hi Cimperiali,

I checked your code, it is much clean and clear well coded I say it make my head hurt. I am doing the form2 I did code is sorta semi working I was wondering if you have spare time could you recheck it and help me out thanks.