View Full Version : Quick Ms Access query


Grahamfff
08-04-2008, 11:48
At least I hope it's easy!

I have a very form in Access which is much too long for the screen.

When I use the scroll wheel on the mouse, this scrolls through the records, whereas I want it to scroll down the form for the record I am currently on.

I probably need to reset a property for the form - but I'm not sure which one! Can anyone help?

Many thanks

ASPGuru
08-04-2008, 15:17
If you first click on the scroll bar so it has the focus and then use the wheel does it still do that?

Grahamfff
08-04-2008, 15:34
Yes, it still scrolls through the records.

If you first click on the scroll bar so it has the focus and then use the wheel does it still do that?

MobileB
08-04-2008, 15:52
Which version of Access you using? The chances are this is what was set up on the design of the form. You need to check the properties/event tab for the form.

Grahamfff
08-04-2008, 16:07
It's Access 2003.

I'm sure you're right that there is a property I need to set correctly, but which one?


I was hopeful when I altered the 'Cycle' property from 'All records' to 'Current record' or 'Current page' - but it didn't have the effect I wanted.

Which version of Access you using? The chances are this is what was set up on the design of the form. You need to check the properties/event tab for the form.

MobileB
08-04-2008, 16:23
Not 100% without looking at it so this is off the top of my head but isn't there a command for OnMouseUp and OnMouseDown. Is anything on that?

Grahamfff
08-04-2008, 16:30
There is, but I'm not sure how to use it.

If I put my curser in the On Mouse Down property field, the drop down offers me only the Autoexec macro I set up or "[Event procedure]" and I don't know what to do from thereon.

I can't help feellnig it should be simpler than this!

Not 100% without looking at it so this is off the top of my head but isn't there a command for OnMouseUp and OnMouseDown. Is anything on that?