MSFlexgrid

[Lynn]

Hi, does anyone know how to clear the MSFlexgrid without touching the first row at run time?

rgds
Lynn

[santulan]

Lynn,
There are two ways -
1. Use Msflexgridq.clear method to clear the contents and then again build heading in the first row using msflexgrid1.formatstring method.

2. I use this procedure to clear the contents except ist row

for i = 1 to msflexgrid1.rows -1
for j = 0 to msflexgrid1.cols - 1
msflexgrid1.textmatrix(i,j) = ""
next j
next i



This is good when data is less.

regards,


Santulan

[Aaron Young]

Clear or Remove?
If you just want them removed, set the Rows Property to 1.

If you want them Cleared, set the Rows Property to 1, then Back to the No. of Rows you Require.


Aaron Young
Analyst Programmer
[email protected]
[email protected]