Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 231
  • Last Modified:

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
0
TerenceHewett
Asked:
TerenceHewett
  • 4
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
No can do.  It can only be a String expression, 255 characters max,

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
If you put something like this:

=Dlookup("xx","yy")

it will simply display

=Dlookup("xx","yy")

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
 
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 MVP, Access and Data Platform)Commented:
you are welcome.

mx
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now