Control Tip or Status Bar Text

[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.

 

[Dirk Goldgar]

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.

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

 

[Steven]

Thank you very much. It is the second one. After seeing
it I think I should have already known this.