BUG: DBGrid Loses All Except One Row After Scrolling to Botto (176563)
The information in this article applies to:
- Microsoft Visual Basic Learning Edition for Windows 6.0
- Microsoft Visual Basic Professional Edition for Windows 6.0
- Microsoft Visual Basic Enterprise Edition for Windows 6.0
- Microsoft Visual Basic Control Creation Edition for Windows 5.0
- Microsoft Visual Basic Learning Edition for Windows 5.0
- Microsoft Visual Basic Professional Edition for Windows 5.0
- Microsoft Visual Basic Enterprise Edition for Windows 5.0
This article was previously published under Q176563 SYMPTOMS
With a bound DBGrid control, navigation is often performed with the
properties and methods of the Recordset object of the Data control. After
such an operation, if the vertical scroll bar of the DBGrid control is
dragged to the bottom, the DBGrid control loses all except the last row of
data. In addition, the vertical scroll bar is lost, making it impossible to
view the rest of the rows.
RESOLUTION
To work around this problem, place the code to ReBind the data in the
RowColChange event of the DBGrid control, as follows:
Private Sub DBGrid1_RowColChange(LastRow As Variant, _
ByVal LastCol As Integer)
If DBGrid1.VisibleRows = 1 Then
DBGrid1.ReBind
DBGrid1.Scroll 0, Data1.Recordset.RecordCount - _
Data1.Recordset.AbsolutePosition
End If
End Sub
STATUS
Microsoft has confirmed this to be a bug in the Microsoft products
listed at the beginning of this article. We are researching this
bug and will post new information here in the Microsoft Knowledge
Base as it becomes available.
Modification Type: | Major | Last Reviewed: | 5/13/2003 |
---|
Keywords: | kbbug KB176563 |
---|
|