Mouse Wheel question



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

Allen Browne

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.


Allen Browne

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

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.

to group, rather than allenbrowne at mvps dot org.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads