I want to scroll MS Flex Grid by code. how it is possible. suppose a grid is having 1000 rec. and after searching a record i want to set focus on that row.
Printable View
I want to scroll MS Flex Grid by code. how it is possible. suppose a grid is having 1000 rec. and after searching a record i want to set focus on that row.
This is the easiest way to scroll through the rows as you are searching through them that I know of anyway, assuming that you only have one column.
Dim r as Integer
With MSFlexGrid1
for r = 1 to .Rows - 1
.Row = r
.TopRow = r
next r
End With
MsgBox r
To select the focus on a row all you do is:
.Row = r
.Setfocus
although I wouldn't reccomend scrolling through the list as you search it. If you had say 1000 rows to search through it may cause the flexgrid to flicker quite a bit. Hope this helps you out.
thanks for the posting and reply...i have similar problem which I've found your posting helpful..
thank to both of you..
any update on this?:D