I have a database which uses a form to collect user data, however if they accidentally use the mouse scroll wheel it scrolls to a new record which means i end up with half records and some very confused users. Is there a piece of code i can put into the form or database to disable the mouse wheel? I dont need it to work at all in this database.

Hi Julie

Thanks for posting your Microsoft Access questiono on the forum. Regarding the answer, there are several ways you could approach it. Apparently there is direct way of programming Access to diable the mousewheel, however, there is a solution.

It involved using a DLL file and having that in the same directory as the database file. Also required is some code on an event to activate the process.

Take a look at this page:
http://www.databasedev.co.uk/disable_mousewheel.html

It contains the files, steps and additional information that you'll need to get the job done.

If you have any further questions regarding Access, or any other Microsoft Office application, please post them to the forum.

Regards

Richard
Microsoft Office Specialist

Thanks - that works perfectly!