Control Tip or Status Bar Text

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

Is there a way to do a function like a

=DLookup( , , ) to display what will show in the Control
Tip or Status Bar

OR Maybe

Doing the DLookup in a different object on the form and
referencing that object for a particular objects Control
Tip or Status Bar Text.

Thank You,

Steven.
 
Steven said:
Is there a way to do a function like a

=DLookup( , , ) to display what will show in the Control
Tip or Status Bar

OR Maybe

Doing the DLookup in a different object on the form and
referencing that object for a particular objects Control
Tip or Status Bar Text.
Click to expand...

I'm not sure I understand what you're asking. You can get a particular
control's StatusBarText or ControlTipText by referring directly to the
control's properties; e.g.,

MsgBox Me.ActiveControl.StatusBarText
MsgBox Me.MyTextBox.ControlTipText

You can also set these properties at run time; e.g.,

Me.MyTextBox.ControlTipText = _
DLookup("SayWhat", "WhatToSay", "ID=" & Me.LkpID
 
Thank you very much. It is the second one. After seeing
it I think I should have already known this.
 
Back
Top