Mouse Wheel question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

As we all know, rolling you're mouse wheel while in a form, will navigate
through records.
Rather than turn this off, can I just make it so that if I roll the mouse
wheel, then it brings me to the last record in a form?

If I select only the form and go to properties, and then go to events, it
show an option for "on Mouse Wheel"
It would seem like I should be able to accomplish goal by taking that path,
but I just don't know what to enter for the code.

Also, why can't someone just tell the form that on Mouse Wheel, GO TO the
current record?
Maybe that isn't possible, but if it is, then that would probably solve a
lot of problems for people.

Thanks in advance
Travis
 
What version of Access is this?

Access 2007 has a Mouse Wheel event.
You can program it to go to the last record with:
RunCommand acCmdRecordsGotoLast

Instructing it to go to the current record would be the same as doing
nothing, since (by definition) the form is already at the current record.
 
It's 2003, but I still have a Mouse Wheel event for the form.
I am interested in sending it to the current record for that exact reason. I
don't want anything to happen when the wheel is moved.
How do I go about sending it to the current record, or make it not do
anything for that matter.

Thanks
Travis
 
For anyone researching this, there's a new article with details of how to
set this up:
Scroll records with the mouse wheel in Access 2007
at:
http://allenbrowne.com/ser-70.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Allen Browne said:
No, that's not going to work in Access 2003.

See:
http://www.lebans.com/mousewheelonoff.htm
Click to expand...
to group, rather than allenbrowne at mvps dot org.
 
Back
Top