Flyover Help for a Control

[JohnHarkins]

Is there a way to create "flyover" help in Acess 97/2000?
I have a control that contains the value of a description field, but the field is too long to fit in the space available.

I'd thought of using a pop-up form, but that seems most appropriate when you're referring to another table/query with multiple records.

There's got to be a way, but I don't know what it would be.

Thanks, John Harkins

 

[beetee]

You should be able to trap MouseMove events for the control to do the fly-over

Then, create table indexed by form name and control name, with associated fly-over text

do something like

if activeform.name <> CurActiveFormName and
activecontrol.name <> CurActiveControlName then

mytable.seek &quot;=&quot;, activeform.name, activecontrol.name
myform.FlyOverTextControl.Label = mytable(&quot;FlyOverText&quot
CurActiveFormName = activeform.name
CurActiveControlName = activecontrol.name
endif

naturally, error checking and whatnot needs to be added.

 

[kewo99]

Here's a couple ideas:

Set the control tip text property or Status bar text property of the textbox during the OnCurrent event of the form:

Me!txtbox.ControlTipText = Left(Me!txtbox & &quot;&quot;, 255)
Me!txtbox.StatusBarText = Left(Me!txtbox & &quot;&quot;, 255)

They are limited to 255 characters in Access 97.

Or
open the Zoom box in the Double Click event of the textbox using:

RunCommand acCmdZoomBox


Ken

 

[beetee]

Please note that the correct terms for the previous example are

Screen.ActiveControl.Name
and
Screen.ActiveForm.Name