access 2003 scroll bar control

[Dausa67]

I have a Issues Database that I am trying to tweek. I need to add a scroll bar to the Issues form in the comments section. I also would like to stop the records from scrolling.

advice?

Clay

 

[missinglinq]

In Design View for the form, select the Comments textbox and goto Properties - Format and set Scroll Bar Property to Vertical.

If by "scrolling records" you mena running thru the records by way of the Mouse Wheel, if you're running Access 2007, you already have a function that addresses this issue! Just check with Help.

For all other versions, you'll need some outside help. A gentleman by the name of Stephen Lebans has a sample database that does this and it can be downloaded at:

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

First, download and unzip the db and take a look. Go into your db and goto File > External Data > Import and import the module modMouseHook from the sample database. Next make sure you have the included file, MouseHook.dll, in the same folder your database resides in. The following code needs to run before the mousewheel will be locked:

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

If you have one form that always loads first in your db, place the code there. If the first form to load varies, place the same code in each form.

You should be set now.


The Missinglinq

Richmond, Virginia

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