Access form stop Scroll button

[ykhamitkar]

Hi there,

I have created one ms access form which based on a table.

Now when I use scroll wheel of my mouse on the form it automatically changes records.

How can I disable scroll wheel

Thanks,
Yogesh

[missinglinq]

Access 2007 has the ability to do this built in. For other versions you have to use an add-in.

Stephen Lebans has a sample database that does this and can be downloaded at:

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

Download and unzip the db and take a look. In your db and goto File > External Data > Import and import the module modMouseHook from the sample database.

You need to place a copy of the MouseHook.dll file in the same folder as your database. It’s normally a Hidden file, so you’ll have to unhide it, Find it, then copy it to the folder.

In the first form to load in your db use this code:

Private Sub Form_Load()
   ' Turn off Mouse Scroll
    blRet = MouseWheelOFF
End Sub

Good Luck!

Linq ;0)>