Mouse Wheel Scroll Problem in Access

[Barry Young]

Platform Access 97

I have a Form that is tied to a dynaset or query.

Now for the problem. I have the form w/ a record in view, and I move the
mouse wheel towards me or down, the record moves out of view, like it is
adding a new record??

Does anybody know no a way to trap the mouse wheel movement? It appears not
to trigger any mouse events. It doesn't seem to trigger any event when the
record is moved out of view. When you scroll up with the mouse wheel, the
record redisplays and the form current event is triggered.

Thanks!

Barry

 

[Van T. Dinh]

See Stephen Lebans' Web site:

http://www.lebans.com/mousewheelonoff.htm

 

[Stephen Lebans]

Van I introduced a bug during an update a few weeks ago to handle TAB
controls. WIth a MultiLine TextBox control, under certain circumstances,
the MouseWHeel is still enabled. I'll post a fix this week.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[jmallord]

scroll mouse trapped?

new to pc review, but i was looking for something very similar to Barry Youngs problem; my issue was the form would move to new record with the scroll mouse, appears to be solved with the following two procedures:

Private Sub Form_Load()
'bookmark current record so new record doesn't interfere...
bkCurRec = Me.Bookmark
end sub

Private Sub Form_Current()
Dim intNewRec As Integer

intNewRec = Me.NewRecord
If intNewRec = True Then
DoCmd.CancelEvent
RunCommand acCmdRecordsGoToPrevious
RunCommand acCmdApplyFilterSort 'this was for a subform refresh
end sub