[Hookette]

Is there any way to create a hoverover for a form field? I have a form and I
would like it to give you hints on what to enter when you put your mouse over
the field.

Thanks.

[Graham Mayor]

No! Form fields provide three forms of help.
1. Help text that is printed in the status bar
2. Help text thatresponds to the F1 key
3. Help text that is activated by a macro either automatic or run on entry
to a form field
or a combination of all three.
For the first two check the field properties
For the last you could use code such as

Sub AutoNew()
Dim sMsg As String
Dim sVer As Integer
sMsg = "Refer to status line at bottom of screen for field entry details" _
& vbCr & "Use the tab key to move between fields"
sVer = Application.version
If sVer 12 Then
Assistant.On = True
Set Balloon = Assistant.NewBalloon
With Balloon
.Text = sMsg
.Button = msoButtonSetOK
.Animation = msoAnimationBeginSpeaking
.Show
End With
Else
MsgBox sMsg, vbInformation, "User Information"
End If
End Sub

http://www.gmayor.com/installing_macro.htm

in the form *template* to draw users attention to the help you wish to
provide. This does of course entail distributing the form as a template.
Issuing *documents* with macros creates a whole new set of problems
--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Hookette wrote:
Is there any way to create a hoverover for a form field? I have a
form and I would like it to give you hints on what to enter when you
put your mouse over the field.

Thanks.