Continuous dynamic tooltip

Question

The problem is that I have a continuous form, and there is a column that the tooltip is not the same for all rows.

For instance:

Users are used to transfer registers as numbers, so I will display the number, and I would display the full name in the tooltip. This way I save space and there is no scrollbar.

What I did is put a hidden field with a tooltip value, then in my current form event I have

txtRegionID.controltipText = hiddenRegionName 

As I thought, a tooltip is set for the first value for each row.

I think this is not possible, because the continuous form is similar to one form, so it is always the same control, and you cannot change its properties depending on the records.

I'm right? Is there any way to do this?

thanks

Answer 1

As you can see in the figure below, row 3 is selected, and row 1 has a hint that shows Tip Three, which is not true for row 1, but true for row 3. The row of the status bar displays Tip Three, which is the right tip for the row. The status bar will only be displayed when a row is selected.

 Private Sub Form_Current() Me.ID.ControlTipText = Me.Tip Me.ID.StatusBarText = Me.Tip End Sub 

Answer 2

Perhaps try the tooltip code from Stephen Leban's website - it allows you to display the current value in a continuous form (among other things).

It may not work in new versions of Access - 2007+. The author has also walked away from Access stuff, so don't look for support there.