ControlTip Text Lookup 1

[rccline]

Can I do a lookup for Controltip Text?

I want to show a controltip for a field in a query result.

Thanks.

Robert

 

[Remou]

You can only have ControlTips on forms. They can be set programmatically.

 

[rccline]

Yes. I understand that. I am refering to control tip in a form. But, I want to display the result of a query in the text as I move the mouse over the control on the form.

Robert

 

[Remou]

I have not tested, but you could try the mouse move event to set controltip text. It would need to be a very quick query indeed.

 

[SeeThru]

You could use oncurrent to set the control tip value for the relavent fields (assuming you do not use continous forms)

SeeThru
Synergy Connections Ltd - Telemarketing Services

http://www.synergyconnections.co.uk

 

[rccline]

How do you set the control tip value for the result of the query?

A little more combersome, but alternatively, perhaps a command button to disply a message box that displays the result of the one-field query. The query produces number.

Thanks.

Robert

 

[Remou]

An example using DLookUp:

Private Sub txtText_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
Me.txtText.ControlTipText = Nz(DLookup("ID", "Table1", "Text='" & Me.txtText & "'"), "NA")
End Sub

 

[rccline]

Thanks Remou!

Robert