Mouse Wheel question

[Tdahlman]

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

 

[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.

 

[Tdahlman]

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

 

[Allen Browne]

No, that's not going to work in Access 2003.

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

 

[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
at:
http://allenbrowne.com/ser-70.html

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

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

No, that's not going to work in Access 2003.

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

to group, rather than allenbrowne at mvps dot org.