Hi everyone!

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?

Thanks!

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.

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:



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...

Thanks!

The property in the form design property sheet is "ControlTip Text".

Put the hint text you want to use in this property.

Mike

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.

Mike

Try This: In The On Focus Event

MsgBox "The Value For this control is " & Me.txtSpecificObj.Value

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.

Mike

Ahhhhhhhhhh............... Thanks Mike for pointing that out you are correct that will not work !

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.

Allright guys, thanks a lot! I'll try to figure something else!