ControlTip Text

  • Thread starter Thread starter PayeDoc
  • Start date Start date
P

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
 
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
 
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
 
Back
Top