What is this feature called?

[silentvet]

Relating to Microsoft Access forms. (I use Office Pro 2010)

I've seen a feaure that allows the TEXT in a MEMO field to pop-up when you do a mouseover. It's mostly used when the total text of a field is more than the size of the form field.

Yet I cannot determine how to do this because I do not know how Microsoft defines this feature.
Can someone help?

Thanks!

 

[randy700]

Sounds like the MouseMove event.

Randy

 

[PHV]

In the MouseMove event procedure 'as suggested by Randy):
DoCmd.RunCommand acCmdZoomBox

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[silentvet]

Thanks for the response, Randy, but the documentation says that the MouseMove event pertains to freestanding labels on a form.

You see, I have a field called NOTES in which I enter notes concerning a specific contact with a client. Sometimes the NOTES are quite lengthy. My NOTES field is a MEMO type and less than an inch in height. Currently, in order to view the notes I must scroll down within the NOTES field.
I saw another Access DB (I don't recall where) that was designed in such a a way that if I held the cursor over the field for more than one second a POP-UP would appear displaying the full text in the field.

Any idea on how that was done?
Many thanks!

 

[missinglinq]

Don't know what 'documentation' you're referring to, but all Controls have a MouseMove event, including Textboxes!

Rsndy's and PHV's advice is dead on!

The Missinglinq

Richmond, Virginia

The Devil's in the Details!

 

[silentvet]

Thanks to all!!

You have all helped me just as I believed you could! My biggest problem was not knowing how to look up something without knowing what it could be called. Is it a Zoom? Is it a re-SIZE? Now I have had some clarity and I have even found a better solution than MouseMove.

So, once again - thanks. I have been able to find several solutions that I can digest that should enable me to come up with something that works for my situation.

The FREE MARKET reigns!

 

[shaunacol]

I would love to use this feature but it doesnt work for me. When I put the code above behind mouse move and then try to hoover over the text box nothoing happens. I dont understand why but if anyone has any ideas I would love to know them thanks

 

[missinglinq]

Where did you place the code? It cannot be in the OnMouseMove Property in the Property Pane, it has to be in the Code Module for the Form. Assuming that your Textbox is actually named Notes, it would be

Private Sub Notes_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
 DoCmd.RunCommand acCmdZoomBox
End Sub

If Notes isn't the name you'll need to replace it with the actual name. And since you're using Access 2010, the File itself would have to be in a Folder that has been declared as 'Trusted.'

The Missinglinq

Richmond, Virginia

The Devil's in the Details!

 

[shaunacol]

Sorry it works now. I closed down the database and when I opened it again it started working. It is a great little feature thanks

 

[missinglinq]

Glad we could help!

The Missinglinq

Richmond, Virginia

The Devil's in the Details!