Object Reference > True DBGrid Events > Scroll Event |
Scroll Event
The Scroll event occurs when the user scrolls the grid horizontally or vertically using the scroll bars.
object_Scroll (Cancel As Integer)
Arguments
Cancel is an integer that may be set to True to prevent the scroll operation from occurring.
This event is fired before the grid is repainted to display the results of the scroll operation. If you set the Cancel argument to True, the scroll operation fails and no repainting occurs.
It is not necessary to execute the Refresh method within this event procedure. Doing so causes the grid to be repainted even if the Cancel argument is True.
You can use this event to perform calculations or to manipulate controls that must be coordinated with ongoing changes in the grid's scroll bars.
Note
Within this event procedure, the values of the FirstRow and LeftCol properties are not updated to reflect the pending scroll operation. You cannot determine the orientation or magnitude of the pending scroll operation by examining these properties.
Avoid using a MsgBox (Visual Basic) statement or function in this event.
This event only fires when the user operates the scroll bars; it will not fire in response to keyboard navigation, data control notifications, or code.