Binding a record field to a tooltip?

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

Hi All,

I have a continious form, which has a load of questions on it.

This comes from two tables.

I have questions and questiondesc.

What I wondered possible was to not show the questiondesc on the form,
but have it is a tooltip when you hovered the mouse over the question
field?

Is something like this possible?

Many Thanks!

Adam
 
Adam,

See if this does it for you... On the Current event of the form, put
code like this:

Me.Question.ControlTipText = Me.Questiondesc

This will mean you will need to click in the record, or otherwise make
the record current before the tooltip will accurately reflect the
correct Desc for that record, so I can see the potential for confusion
on a continuous form.
 
This is a really good! Although only allows for up too 255 characters,
so could be a problem : (
 
Adam,

Here's a suggestion for an alternative approach...

Put a control on your form for Questiondesc, and make it very small so
it is not seen, and set its Tab Stop property to No.
On the Dbl Click event of the Question textbox, put code like this...
Me.Questiondesc.SetFocus
DoCmd.RunCommand acCmdZoomBox

Try that and see how you like it.

You could use the Mouse Move event, but I would not do so myself. And
it has the disadvantage of course that the user has to actively close
the zoom box. But I think that's how I would end it doing it.
 
Thank you Steve, this is really good!

Steve said:
Adam,

Here's a suggestion for an alternative approach...

Put a control on your form for Questiondesc, and make it very small so
it is not seen, and set its Tab Stop property to No.
On the Dbl Click event of the Question textbox, put code like this...
Me.Questiondesc.SetFocus
DoCmd.RunCommand acCmdZoomBox

Try that and see how you like it.

You could use the Mouse Move event, but I would not do so myself. And
it has the disadvantage of course that the user has to actively close
the zoom box. But I think that's how I would end it doing it.
Click to expand...
 
Back
Top