Mouse over Event

[Guest]

I have a field that does not display all the data. Can any tell me is there a
way using a mouse over event that another box (like a tooltip) appears
displaying all the data to prevent having to increase the filed size

much obliged

 

[Guest]

Hi

There are a number of methods to do what you want this is just one.

Creat a new box called SomeOtherBox

Private Sub Form_Load()
Me.SomeOtherBox.Visible = False
End Sub
___________________________
Private Sub YourTextBox_Click()
Me.SomeBox.Visible = True
End Sub

Or some other event
___________________________
Control Source for [SomeOtherBox]
=[YourTextBox]


Of course you can make this better by using the [SomeOtherBox] only when the
word count is too big for [YourTextBox]

If XXXXX, show [SomeOtherBox]
End If

Sorry no more time - off to work - toooo early for this. Hope this helps
and points you in the right direction

 

[fredg]

I have a field that does not display all the data. Can any tell me is there a
way using a mouse over event that another box (like a tooltip) appears
displaying all the data to prevent having to increase the filed size

much obliged

Code that control's MouseMove event:
Me![ControlName].ControlTipText = Me![ControlName]

Since you have to hover over the control for a few seconds to display
the control tip text, it might be simpler and quicker to code the
control's Double-click event:

DoCmd.RunCommand acCmdZoomBox