Jun 26 2006, 04:17 PM
When using almost any Microsoft software, when you get your mouse over a control, there's a small yellow bubble showing up that displays some info about the control.
Is there a fast way to add something similar in my Access screens?
Jun 26 2006, 04:19 PM
I believe it is the ControlTips property of a particular control. There is some upper limit on how much text but I don't know what it is.
Jun 26 2006, 04:36 PM
Frank, you're right!
I still have a problem: I'd like to use this on a continuous form and when the mouse is on the textbox, I'd like the controltip to display the whole textbox value. I'm using something like this but it always displays the record with the focus on:
Private Sub txtSpecificObj_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
Me.txtSpecificObj.ControlTipText = "" & Me.txtSpecificObj.value
I'd like the controltip to display the record that the mouse is on instead of the record with the focus but I don't have a clue how to do it...
Jun 26 2006, 04:37 PM
The property in the form design property sheet is "ControlTip Text".
Put the hint text you want to use in this property.
Jun 26 2006, 04:40 PM
Oops - just saw the next question you posted -- afraid you can't use the technique you are attempting because the current record is really the only record the form knows about. The rest of the fields/records are merely "painted" as graphics.
Jun 26 2006, 04:43 PM
Try This: In The On Focus Event
MsgBox "The Value For this control is " & Me.txtSpecificObj.Value
Jun 26 2006, 05:43 PM
That won't work - the poster is attempting to have the mouse hover over a field in any row of a continuous form and have the field value show in the control tip. Your GotFocus suggestion would require the user to set focus to the field on the row containing the desired record.
Jun 26 2006, 06:41 PM
Ahhhhhhhhhh............... Thanks Mike for pointing that out you are correct that will not work !
Jun 27 2006, 08:11 AM
As Mike has pointed out, there's no way to do this. The selected record is the Active record as far as Access is concerned. You need to select the record FIRST, then your code might work.
Jun 27 2006, 11:18 AM
Allright guys, thanks a lot! I'll try to figure something else!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here