Is it possible to set up control tips using DLookup?

H experts,

I would like to set up my control tip text as a dlookup as there are many buttons within my application that use the same text and I do not want to duplicate the work.

Any ideas?

Thanks.
Terry
TerenceHewettAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
However, you could I suppose set the Control Tip Text on the fly in the On Load event ... getting the text via a DLookup () ...

Like so:

Private Sub Form_Load()
    Me.Text1.ControlTipText = DLookup("SomeField", "SomeTable")
End Sub

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
No can do.  It can only be a String expression, 255 characters max,

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
If you put something like this:

=Dlookup("xx","yy")

it will simply display

=Dlookup("xx","yy")

mx
0
 
TerenceHewettAuthor Commented:
MX,  thanks very much.  I think your last post is exactly what I was looking for. Will try and then start a new post ifI still have issues.
Best regards,
Terry
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
you are welcome.

mx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.