flexgrid memory error

[wolfrose]

Is there a limit as to the number of cells you can have in a flexgrid? I keep getting a runtime error 30006: Unable to Allocate Memory for Flexgrid error. Is there a way around this, besides the obvious way of splitting up the flexgrid of course.

[nemaroller]

Well... from my tests... you can make 175,000 rows of two columns...

if you use 5 columns, your limited to 70,000 rows

if you use 50 columns, your limited to 7000 rows

500 columns, your limited to 700 rows


so your answer is 350,000 cells... regardless what you put in them.

[wolfrose]

I guess I should count it a blessing that the company I work for has outgrown the controls in VB

[nemaroller]

The important thing to remember is...

the flexgrid is not a spreadsheet. And most people wouldn't peruse 350,000 cells... so it really wasn't a requirement to include such capacity in an on-screen control, because the capability exists to load data in and out from a behind-the-scenes array. And an array can hold as much information as the system memory can support.