Mouse scroll wheel with forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vilem Sova - 12 Dec 2006 06:21 GMT

I have a data-entry form that's bound to a recordset, and uses the "where"
clause to go to a required record for editing, and the "acNewRec" option
when moving to a new record for data entry. However, when users scroll the
mouse wheel when in the form, the form goes to a new record. This causes
unwanted problems (and a lot of confusion for the users). I don't want the
users scrolling to a new record when already in a record that they're
editing. Note that the "Cycle" property has been set to "Current Record".

Is there some way to turn off this "feature"? Or alternatively, is there
some workaround?

Thanks,
Vilem Sova

Reply to this Message

Rob Parker - 12 Dec 2006 06:45 GMT

Use the solution Stephen Lebans provides:

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

Rob

>I have a data-entry form that's bound to a recordset, and uses the "where"
>clause to go to a required record for editing, and the "acNewRec" option
[quoted text clipped - 9 lines]
> Thanks,
> Vilem Sova

Reply to this Message

Allen Browne - 12 Dec 2006 06:47 GMT

The mouse wheel does not change records in Access 2007. You can still scroll
records in a continuous form or datasheet, and you can use the MouseWheel
event if you want to scroll records as previous versions did, but it no
longer has that annoying behavior by default.

For earlier version, see:
http://www.lebans.com/mousewheelonoff.htm

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have a data-entry form that's bound to a recordset, and uses the "where"
>clause to go to a required record for editing, and the "acNewRec" option
[quoted text clipped - 6 lines]
> Is there some way to turn off this "feature"? Or alternatively, is there
> some workaround?

Reply to this Message

Damian S - 12 Dec 2006 06:49 GMT

Hi Vilem,

Try this excellent item from Stephen Lebans.

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

Damian.

> I have a data-entry form that's bound to a recordset, and uses the "where"
> clause to go to a required record for editing, and the "acNewRec" option
[quoted text clipped - 9 lines]
> Thanks,
> Vilem Sova

Reply to this Message

missinglinq - 12 Dec 2006 11:57 GMT

And to think, only last month I had someone take me to task when I suggested
that the most commonly used answer to this problem was Stephan's routine!
It's good to know MS finally addressed the mousewheel problem, Allen, but as
we all know, clients, unless they just opened for business, seldom have the
latest version of Access!

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Reply to this Message