try removing the fixrows (grd.fixrows=0) before you change the
recordsource then set the fix row again after the set datasource=rs.

a. pajarillo


> All,
>
> I'm having problems with an MSHFlexgrid control. It's bound to an adodc;
>  and I change the recordsource at runtime. It has 1 fixed row, which
> contains the column headers.
>
> The problem is that after I change the recordsource, and then refresh
> the  recordset, the grid displays the first fixed row, then a blank
> "row" (it  doesn't really look like a row; it's just a grey area) that
> is the same  height as my fixed row, and then the rows that contain the
> data. The  serious issue is that it does not display all the data; it's
> as if the  display area below the fixed row has all shifted down, and
> there is still  data in the "grey" area, and the actual display of row
> data begins after  the grey area.
>
> I'll try to draw it in ascii:
>
> (Before adodc.refresh)
>
> Col1   Col2   Col3
> ------------------
> Jim    Tom    Tim
>        Fred   Sam
>        Bob    Joe
> Jill   Pam    Sue
> Fred   Gus    Ted
>
> (After adodc.refresh)
> Col1   Col2   Col3
> ------------------
> [GREY AREA        ]
> Jim   Tom     Tim
>       Fred    Sam
>       Bob     Joe
> Jill  Pam     Sue
> {This is where fred, gus and ted should be, but are gone}
>
> Any ideas? Refresh doesen't help ....
>
> Thanks
> Matt
>
>
>
> ---
> Visual C# - A Guide for VB6 Developers
> This book will make it easy to transfer your skills
> from Visual Basic 6 to C#, the language of choice
> of the .NET Framework.
> http://www.wrox.com/ACON11.asp?ISBN=1861007175&p2p0059
>