Full Version: (2) ?'s 1.Mouse Wheel - Permanently Disable? 2.Bound field-Expan
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
husker
1) Excuse me for being green but I have read the 'Mousehook" solutions as posted online and have a question:

a) First, Is this code only for putting 'on' / 'off' buttons on the database?

b) Is there a way to disable it without having those button options - So that you never have to bother with it, the mouse-wheel will never affect you database?

2) I have a form that contains fields bound to a table. There is 3-4 sentences of information in these columns the fields are linked to. On the form, even horizontally stretching the field across the whole page in deisgn view does not fit all of the contents in that table column. If I stretch the field vertically, all the form shows is the next record from the row in the table.

a) How can a bound field show ALL of the contents in the table when there is a paragraph or more of information? In other words, How can I make the bound text field expand to fit its contents?

*** It should be noted: I have virtually no programming experience So you'll have to dumb down your responses.

Thank you kindly!
Jack Cowley
I do not know to which articles about the mousewheel you are referring, but you will find another here that may work for you.

You should be able to expand a text control on a form that is bound to a Memo field in the table so that you can see all the data in the tables field. If what you want is for the control to expand or contract depending on the amount of data to display then you will need code to do that. Here is some generic code that you might use in the forms On Current event:

If Len(Me.NameOfControl) > 50 Then
Me.NameOfControl.Height = 1440
Me.NameOfControl.Width = 2880
End if

Width and height is in twips and I believe 1440 twips equal one inch, but search Access help for the details.

hth,
Jack
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.