Possible to mouse over a bound textbox to show all info in the box?

[taimysho0]

hello, does access have a mouse over feature like in excel where theres a red carrot and if you roll over it, a note appears?


i have a form with a bound textbox. this textbox contains notes. however due to the size of the form, the textbox does not show all of the notes sometimes and user has to click the textbox and scroll to the right to read it. Is there a way the user can mouse over the textbox and another box appears with the full notes in it? if not, is there something similar? thanks!

[taimysho0]

similar to the idea of a tool tip

[taimysho0]

in the controltip property of the textbox, is there a way for me to use the control source of the textbox itself?

[Missinglinq]

The Command for this is acCmdZoomBox. The problems with using this in conjunction with the MouseMove event is that it

• Zooms the Control that currently has Focus, not the Control whose MouseMove event is executing the Command
• Zooms that Control on the Record that has Focus (is the Current Record).

The best way to do this is to use the Control's Double-Click event to expand it. That way you know you're getting the data for that Control on that Record:

Private Sub TargetTextbox_DblClick(Cancel As Integer)
 DoCmd.RunCommand acCmdZoomBox
End Sub

Linq ;0)>

[John_G]

Missinlinq is right, but be aware that if the textbox has any code in the OnClick event, it will also be executed, before the DoubleClick event code is executed.

John