ControlTip Text

[PayeDoc]

Hello All

Is it possible to set a calculated value for this property?
e.g. for a textbox that displays a numerical value, I would like like to display a calculated value, based on the textbox value, to be displayed as ControlTip text.

Can it be done?
I have tried setting the expression directly as the ControlTip Text, but this just shows the expression syntax rather than the expression result.

Hope someone can help.
Many thanks
Leslie Isaacs

 

[Douglas J. Steele]

You can set the ControlTip's property in VBA code:

Me!MyControl.ControlTip = DCount("*", "SomeTable", "SomeField = 123")

You'd have to put that code in an event that would fire each time the value
changes.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Hello All

Is it possible to set a calculated value for this property?
e.g. for a textbox that displays a numerical value, I would like like to
display a calculated value, based on the textbox value, to be displayed as
ControlTip text.

Can it be done?
I have tried setting the expression directly as the ControlTip Text, but
this just shows the expression syntax rather than the expression result.

Hope someone can help.
Many thanks
Leslie Isaacs

 

[PayeDoc]

Hello Douglas

Many thanks.
I initially had a problem with the syntax, but then discovered that
Me!MyControl.ControlTip =
should be
Me!MyControl.ControlTipText =

then - brilliant!

Many thanks again
Les

 

[Douglas J. Steele]

Oops. Sorry about that. Glad you got it working despite me!