Access2000: ControlTipText property

[Arvi Laanemets]

Hi

MS Help does say:
"You set the ControlTipText property by using a string expression up to 255
characters long."

But in Properties window, I can enter only string, not a string expression?
To be more specific, I need this propertie for textbox on contionous form to
be set to
=Iif(HiddenFieldValue=0;""; "Difference: " & HiddenFieldValue)
, so when I hold the mouse pointer over the control, and the value,
calculated in field HiddenFieldValue for this row is not 0, a proper message
is displayed. (All rows where HiddenFieldValue<>0, are also colored by
conditional formatting, but I want to give additional information about how
big and with which sign the difference is.)

With single form, I can use VBA for this, but I think it doesn't work with
contionous forms in a way I want - the tip text depends on active row and is
same for all rows.


Thanks in advance for any help
Arvi Laanemets

 

[Allen Browne]

I doubt there is a way to set the ControlTipText with a value that is
different in different rows of a continuous form/datasheet.

 

[Arvin Meyer]

I doubt there is a way to set the ControlTipText with a value that is
different in different rows of a continuous form/datasheet.

As usual, Stephen Lebans has done it again:

http://www.lebans.com/DownloadFiles/A2kTooltipver34.zip

I don't think his code addresses the poster's question though. As I
understand it, ControlTips cannot be set, at least in the property sheet, to
a function.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access